Replication from MySQL to MS SQL

Question

I ran into a new problem here. I cannot find priority for replication from MySQL running on a Linux server up to MS SQL Server.

Has anyone done this before?

Most importantly, all changes made to the MySQL database must be replicated to the MS database in real time or closed. The MS database is unlikely to be updated in any other way, so a bidirectional tool is not required.

---

I thought one way is to read the changes from the binary log. Has anyone understood before?

Thanks for helping the guys.

Answer 1

MySQL UDF, ODBC MSSQL. , .

:

• MySQL, , .
• MSSQL ODBC , .

, T-SQL MySQL SQL , CUD.

Answer 2

, DBSync ,

Answer 3

, MSSQL 2008 Mysql .

I tried this application http://enterprise.replicator.daffodilsw.com/ and it worked, but it did not look reliable. But you can check that I'm wrong.

Finally, I decided to use the OLE DB and postgress interface instead of Mysql. It is working correctly.