Sql Server 和 Mysql Server 之间的同步
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1951174/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Sync between Sql Server and Mysql Server
提问by fatnjazzy
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.
我在 sql server 中有 2 个大表，我需要同步到 mysql。现在，我需要将其作为一个持续的过程。每个表是 1 GB，每 0.1 秒获取新/更新/删除行。
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
谢谢
回答by OMG Ponies
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.
您可以在 SQL Server 中创建一个链接服务器实例，指向 MySQL 实例。 本文给出了分步过程。一旦到位，假设您授予您代表适当权限连接的 MySQL 用户，您可以根据需要写入 MySQL 实例。因此，您可以轻松地更新存储过程以执行将记录插入 MySQL 的附加步骤。
