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
Robbe Morris replied to santhosh kumar on 26-Jun-14 10:07 AM
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.
santhosh kumar replied to Robbe Morris on 26-Jun-14 11:06 AM

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


Thanks,

Santhosh