SQL Server - SQL Server to MySQL Replication - Asked By santhosh kumar on 26-Jun-14 06:13 AM

Hi,

We have a requirement where there is a necessity to push data from sql server tables to my sql database.

So that the report server traffic will move to mysql rather than sql server. Please let me know your suggestions.

Thanks,
Santhosh

There is nothing native in SQL Server that supports this that I'm aware of.  You could try something like SymmetricDS but I've never used it.

I don't think there is another alternative than writing the code to copy the data into MySQL.

Can I do the same with nosql such as couchbase to improve performance.

Thanks,

Santhosh