CODEWITHSUNDEEP
mysqlsqldb2
xaberue
xaberue

Reputation: 336

Synchronize some tables from two databases in different DBMS

I want to synchronize some tables from two databases in different DBMS (DB2 and MySQL). How can I do that without writing code in any of the applications that use these databases? Any idea?

The application that use DB2 has been written in Java, the other one is a SuiteCRM

Thanks!

Upvotes: 0

Views: 176

Answers (1)

AngocA
AngocA

Reputation: 7693

You can adapt some tools to perform what you want:

  • Have a master table (MDM) in a database and have a replication or federation in the other databases. (MDM software, or equivalent)
  • Create a trigger in DB2 that calls a external UDF that writes the values in MySQL. Probably, you will need a similar thing in MySQL but not idea if that is possible. (In-house development)
  • Create an alias table in DB2 by using federation (information integration) that uses the MySQL table, in that way DB2 inserts directly in MySQL. (extra license)

Upvotes: 0

Related Questions