How can I synchronize my MSSQL database with MySQL?

Question

I use MSSQL as my transactional database. This database contains over 200 tables with approximately 25 tables that contain 1M plus records. I want to replicate data with the same structure to the MySql database for reporting. Is there a tool or method that can do this in fairly real time?

Answer 1

Use SQL Server Linked Server to access MySQL with SQL Server.