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
