Move data from MS SQL to MySQL

Question

I have one MS SQL DB (very big) and MySQL. I must move data from MS SQL DB to MySQL by doing SQL. It mean that source data & destination data arenot same structure. When source data is updated, the updating is reflected into destionation. Please give me an advice which is the suitable way?

1. Using SSIS
2. Using store procedure & write my own script
3. Other way.

Any advice is highly appreciated.

Answer 1

Cleanest way will be using stored procedures since it is not a complete immigration. By doing this you will have everything under control. MSSQL has a nice feature linked servers, a bit slow but worths it in most of cases. You can find instructions here: http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx

An example:

UPDATE your_mysql_database.dbo.your_mysql_table SET col1=...