Bi-directional sync between SQL Server and MySQL databases
Is there a way to build bi-directional sync between two different database engines/schemas (SQL Server and MySQL). I have been able to do one directional sync (which is truly a migration/ refresh).
I created a syncjob that moves data from SQLServer to MySQL (using tMap) and onComponentOk (not sure what that means) on the MySQL end it moves data from MySQL to SQLServer. Both are setup for update and insert.
SQLServer > MySQL - Insert - works
MySQL > SQL Server - Insert - works
SQLServer > MySQL - Update - works
MySQL > SQLServer - Update - does not work
Any ideas/ samples on how to get bi-directional data sync working would be appreciated.
Iam on TOS 4.0
Omega Sync from Spectral Core (
http://www.spectralcore.com/omegasync/) can compare and synchronize SQL Server and MySQL. It even has a built-in scheduler if you need ongoing synchronization.
Damir
