Bi-directional sync between SQL Server and MySQL databases

Anonymous — Sat, 16 Nov 2024 13:27:18 GMT

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

Re: Bi-directional sync between SQL Server and MySQL databases

_AnonymousUser — Wed, 15 Sep 2010 07:37:22 GMT

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

topic Bi-directional sync between SQL Server and MySQL databases in Talend Studio

Bi-directional sync between SQL Server and MySQL databases

Re: Bi-directional sync between SQL Server and MySQL databases