bidirectional sync between SQL server and MySQL tables

Question

I want to setup a bidirectional sync between local tables in SQL Server database and remote tables in MySQL database.

After many search, I find two ways:

1- Microsoft Sync Frameworke, but you must implement you own custom provider.

2- using SSIS and linked server as you can find [here]:Sync Framework: Oracle/SQLServer

By using the second solution, I succeeded just in doing the synchronization in one direction.

Can someone help me doing the bidirectional sync ?

Vladimir Semashkin · Accepted Answer · 2014-06-15 18:03:39Z

1

In connection with my experience SSIS is the best way. I don't see any problems of synchronization back from mySql. You just should make 'buffer' database and organize process of merging data in this database from SQL server and MySql. After merging, values should be applied to both databases.

But, you can check such solutions like Oracle Golden Gate. This solution is pretty expensive, but in could provide real time synchronization for cross platform data. Solution depends on question 'how often data should be synchronized'

edited Jun 15, 2014 at 18:03

answered Jun 15, 2014 at 17:53

Vladimir Semashkin

1,2801 gold badge10 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

bidirectional sync between SQL server and MySQL tables

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related