Sql Server和Mysql Server之间的同步 [英] Sync between Sql Server and Mysql Server

问题描述

我在sql server中有2个大表，我需要同步到mysql. 现在，我需要将其作为一个持续的过程. 这些表各有1 GB，并且每隔0.1秒就会获得更新/更新/删除行.

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.

您能向我推荐一种可以做到这一点的工具吗?它并不昂贵.

Can you recommend me a tool that can do it that is not resource expensive.

您还可以提供OPEN SOURCE和商业广告

you can offer OPEN SOURCE and commercial as well

谢谢

推荐答案

您可以在SQL Server中创建一个链接服务器实例，指向MySQL实例. 本文提供了以下步骤:分步过程.一旦到位，只要您授予MySQL用户以适当的权限代表您连接，就可以根据需要写入MySQL实例.因此，您可以轻松地更新存储过程，以执行附加步骤以将记录插入MySQL.

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 Server之间的同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！