从MySQL复制到MS SQL [英] Replication from MySQL to MS SQL

问题描述

我在这里面临着新的挑战. 我似乎找不到从MySQL(在Linux机器上运行到MS SQL Server)上进行复制的优先顺序.

I'm facing a new challenge here. I can't seem to find precedence for replication from MySQL, running on a Linux box to MS SQL Server.

有人做过吗?

最重要的是，对MySQL数据库所做的所有更改都应实时或关闭复制到MS数据库上. MS数据库不可能以任何其他方式更新，因此不需要双向工具.

Most importantly all changes made to the MySQL database should be replicated on the MS database realtime or close. MS database are not likely to be updated in any other way, so a bidirectional facility is not required.

我认为一种方法是从二进制日志中读取更改. 有人解析过吗?

I thought one way is to read the changes out of the binary log. Has anyone parsed one before?

感谢您的帮助.

推荐答案

MySQL中的触发器可用于捕获更改并调用UDF，然后UDF可以执行对MSSQL的ODBC查询.但是，性能可能会很糟糕.

Triggers in MySQL could be used to catch changes and call a UDF, which could then execute ODBC queries to MSSQL. Likely terrible for performance, though.

如果不需要立即复制:

• 在MySQL中编写触发器，以捕获日志表中的插入，更新和删除语句.
• 使用ODBC从MSSQL轮询日志表并执行它们，然后删除这些日志条目.

当然，T-SQL和MySQL的SQL变体并不完全相同，但是对于微不足道的CUD操作，它应该是紧密的.

Of course, T-SQL and MySQL's variant of SQL isn't exactly the same, but it should be close for trivial CUD operations.

这篇关于从MySQL复制到MS SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！