Hello,
My question is fairly straightforward: I am using a SyncOrchestrator to synchronize between two databases, and I am wondering if there is a simple way to ensure that some of my custom "after update" triggers do not get fired in the sync process. Under
normal circumstances, I wish for these triggers to behave when certain columns are updated in a table, however the sync process upon updating these columns is (naturally) firing the triggers as well. Is there a simple way to avoid this? I have
attempted to introduce a flag which the trigger checks during a sync, however this solution is not fullproof in my opinion (i.e. the flag may be left set to a value which I do not want).
My question is: is there an elegant to prevent ANY triggers from being fired when performing a sync orchestration?
Perhaps another question: is a sync run automatically in a transaction? If so, is there a way to add custom commands to a sync transaction?
Thank you,
T. Andreasen