MySQL Forums
Forum List  »  Triggers

Synchronizing data between different databases/tables
Posted by: John Hundley
Date: October 18, 2010 10:52AM

Hi,
I need to integrate two stovepipe systems and I need to synchronize a couple of tables between them. There will be two databases running on the same server. There are tables in each database that a similar but not exactly the same, each system monitors changes to it's database and behaves accordingly. What I want to do is put AFTER_UPDATE triggers on these tables and then update their corresponding table in the other database. Here is my concern, if I have an AFTER_UPDATE trigger on both tables I will get into an endless loop. Is there a way to turn off the AFTER_UPDATE triggers only during the trigger updates between the two tables?
Thanks,
John

Options: ReplyQuote


Subject
Views
Written By
Posted
Synchronizing data between different databases/tables
6224
October 18, 2010 10:52AM
1755
October 21, 2010 01:01PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.