Replication between SQL Server and MYSQL

Question

I am trying to configure replication between SQL Server 2008 and MYSQL. I installed the MySQL ODBC 5.1 driver on the MySQL server. At first, I tried to just set up a linked server between two databases that are working fine.

However, now I am trying to configure replication in SSMS. I created a simple post, but I'm having trouble setting up a subscriber. The only heterogeneous data sources that I can configure in Oracle and IBM. However, I believe that I should use the ODBC driver installed and replicated to the MySQL database.

Any ideas ?! Thanking someone in advance

Answer 1

The documentation is very simple: only Oracle and DB2 are supported, and only when using OLE DB, not ODBC. Therefore, trying to set up replication on MySQL using ODBC is almost certainly a waste of time.

Having said that SQL Server Native Replication is not the only way to copy data between databases, and if you can provide additional information about your requirements, then someone might have an alternative solution.

For example, if your goal is some form of reporting or data warehouse, you can familiarize yourself with the many ETL tools that are available and work with many different databases. (I assume that your goal is not redundancy or accessibility, because you are using two different platforms.)