Sync between Sql Server and Mysql Server

Question

Hi, I have 2 big tables in sql server that i need to sync to mysql. now, i need that as an ongoing process. the tables are 1 GB each and getting new/update/delete row every 0.1 second.

Can you recommend me a tool that can do it that is not resource expensive.

you can offer OPEN SOURCE and commercial as well

Thanks

Answer 1

You could create a linked server instance in SQL Server, pointing to the MySQL instance. This article gives the step-by-step process. Once that is in place, providing you grant the MySQL user you connect on behalf of proper permissions, you can write to the MySQL instance as you like. So you could easily update stored procedures to do an additional step to insert records into MySQL.

Answer 2

Much easier solution is to use commercial application - Omega Sync from Spectral Core can compare and synchronize SQL Server with MySQL (and supports other databases, too). It has a built-in scheduler, which will help as you said you need ongoing synchronization.