Is there a way I can have a constant update of my SQL Server data going to a MySQL database?
+1
A:
Exactly how big of a delay is acceptable will more or less guide the type of solution you use.
- Updates need to be (near) real-time: you need to either (a) have whatever is pushing the data to MSSQL also push to MySQL at the same time, or (b) use replication to do it
- Updates can be delayed a while: then instead of trying to replicate things you can make it into an ETL process, where you have a few options, the best of which is probably using SQL Server Integration Services (SSIS) where you can design ETL packages to do the push any way you want
Daniel DiPaolo
2010-04-22 19:07:33
Third alternative, use triggers to put records ina staging table and then run a job every X number of minutes to move those records. Do not try to use a trigger to push directly to a mySQL database as it can cause issues if that database goes down.But I like your alternatives best.
HLGEM
2010-04-22 19:10:58