开发者

Constant Push of SQL Server data to MySQL

开发者 https://www.devze.com 2022-12-28 07:57 出处:网络
Is there a way I can have a constant update of my SQL Server开发者_如何学Go data going to a MySQL database?Exactly how big of a delay is acceptable will more or less guide the type of solution you use

Is there a way I can have a constant update of my SQL Server开发者_如何学Go data going to a MySQL database?


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
0

精彩评论

暂无评论...
验证码 换一张
取 消