Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Sync between Sql Server and Mysql Server

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

like image 850
fatnjazzy Avatar asked Dec 23 '09 07:12

fatnjazzy


1 Answers

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.

like image 134
OMG Ponies Avatar answered Sep 20 '22 18:09

OMG Ponies