Hi all,
i'm trying to find a solution for the following problem:
I have two different database called A and B. On database A runs an
application call AA. Some information from the database A is used in
database B. Currently triggers are being used to update the data on
database B when anything changes on database A.
Working this way has the the problem that when database B is offline
or nu fully synchronized with database A error appear in the
application AA.
What i want to do is create a mutation log table and make the triggers
on the A database write their info into this table. On that table i
then want to build another trigger which updates the B database.
Will this work (e.a. will the transaction be splitted) and is this the
best solution or can i try something else.
I already thought of doing an import on the mutationlog table every
minute but i actually do not want to do that.