replicating data from mssql to mysql

Question

Post reply

replicating data from mssql to mysql

Dhruva_51

SSChampion

Points: 10521
More actions
March 12, 2013 at 9:15 am

#271642

Hi,
Any body tried to replicate data real time from mssql to mysql database. I know mysql is not supported as a subscriber in sql server replication. How to achieve this ? I found an article we can achieve this using linked server and SSIS. how to do with SSIS ? How to select the changes and move those changes to mysql? I don't want to use any third party tools over here. Help !!!

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Orlando Colamatteo SSC Guru Points: 182276 More actions · Answer 1

What is the reason you want to replicate to MySQL?

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Dhruva_51 SSChampion Points: 10521 More actions · Answer 2

reason- for reporting purpose and to save money on license fees.

Orlando Colamatteo SSC Guru Points: 182276 More actions · Answer 3

Have you considered the costs associated with

1. Getting an unsupported configuration working initially.

2. Maintaining an unsupported configuration over time.

3. Splitting your development time and expertise across two platforms...the techniques and skills required for writing high-performing code for MySQL are quite different than for SQL Server.

4. Scalability.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Dhruva_51 SSChampion Points: 10521 More actions · Answer 4

Actual thought is to seperate reads and writes traffic to different servers. If it doesn't work we can move back to the actual server. I also thought of using peer to peer replication which can work perfectly in this scenario. Just working on different ideas on how to achieve it.

Orlando Colamatteo SSC Guru Points: 182276 More actions · Answer 5

I suspect peer-to-peer would be practically impossible between MySQL and SQL Server. If you want to split reads and writes SQL 2012 has some great options within the Always On feature-set. Else if you're sticking with 2008 I would recommend a homogeneous setup.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Dhruva_51 SSChampion Points: 10521 More actions · Answer 6

Oh I planned to setup peer-peer on SQL server only. I am not sure how to setup replication to MySQL. Haven't explored new features of 2012.