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.

您也可以提供开源和商业服务

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屋！