I need to keep similar tables in two different databases in synch. This is what I want to do:
-Any column update to database1.mytable should trigger the same column update to database2.mytable.
-Any column update to database2.mytable should trigger the same column update to database1.mytable.
How do I avoid an 'infinite loop' that would be caused by the firing of the triggers?
-Any column update to database1.mytable should trigger the same column update to database2.mytable.
-Any column update to database2.mytable should trigger the same column update to database1.mytable.
How do I avoid an 'infinite loop' that would be caused by the firing of the triggers?