SQL Server和MYSQL之间的复制 [英] Replication between SQL Server and MYSQL

问题描述

我正在尝试在SQL Server 2008和MYSQL之间设置复制.我已经在MySQL服务器上安装了MySQL ODBC 5.1驱动程序.最初，我试图在两个数据库之间建立一个链接服务器，但工作正常.

I am trying to set up replication between SQL Server 2008 and MYSQL. I have installed a MySQL ODBC 5.1 driver on the MySQL server. Initially I was trying to just set up a linked server between the two databases which is working fine.

但是，现在我正在尝试在SSMS中设置复制.我已经创建了一个简单的出版物，但是设置订户时遇到了问题.看来我可以在Oracle和IBM下设置唯一的异构数据源.但是我确实认为我应该能够使用已安装的ODBC驱动程序并将其复制到MySQL数据库.

However now I am trying to set up replication in SSMS. I have created a simple publication but I am having problems setting up the subscriber. The only heterogeneous datasources it seems I can set up under Oracle and IBM. I do however think that I should be able to use the ODBC driver installed and replicate to the MySQL database.

有什么想法吗?！预先感谢任何人

Any ideas?! Thanking anyone in advance

推荐答案

文档很清楚，以任何方式都仅支持Oracle和DB2，并且仅在使用OLE DB而不是ODBC时才受支持.因此，尝试使用ODBC设置到MySQL的复制几乎肯定是浪费时间.

The documentation is very clear that only Oracle and DB2 are supported in any way, and only when using OLE DB, not ODBC. Therefore, trying to set up replication to MySQL using ODBC is almost certainly a waste of time.

话虽如此，原生SQL Server复制并不是在数据库之间复制数据的唯一方法，如果您可以提供有关需求的更多信息，那么也许有人会有替代解决方案.

Having said that, native SQL Server replication is not the only way to copy data between databases, and if you can give some more information about your requirements then someone may have an alternative solution.

例如，如果您的目标是某种形式的报告或数据仓库，则可以研究许多可用的ETL工具，这些工具可以与许多不同的数据库一起使用. (我假设您的目标不是冗余或可用性，因为您使用的是两个不同的平台.)

For example, if your goal is some form of reporting or data warehousing then you can look into the many ETL tools that are available and work with many different databases. (I'm assuming your goal is not redundancy or availability, because you're using two different platforms.)

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