Data synchronization between MsSQL and MySQL
Posted on 2015-01-16
I have to synchronize data between a MySQL database in a website and a MsSQL from an ERP.
I have the knowledge to do it in several ways, but i need an advice from someone that as been trought this waters before or as more experience than me.
What road should i take?..
1. Should i build a webserver with a php based app with cron jobs inside my client infrastructure and connect the website by webservices using json and update both MySQL and the MsSQL ERP databases this way?
2. Should i write a windows C# program that starts automatically with windows, with a timer that checks and connects the website by webservices using json and update both MySQL and the MsSQL ERP databases this way?
3. Should i use a tool from MsSQL to do this, a DTS, ODBC, etc?
4. Should i look for a tool already done for this purpose that is worth the money spent?
Should i use json? xml?... i like more json, is more simple and fast to implement :P
Thx in advanced,