Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

replicating data from mssql to mysql Expand / Collapse
Author
Message
Posted Tuesday, March 12, 2013 9:15 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 8:47 AM
Points: 394, Visits: 1,979
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 !!!
Post #1429890
Posted Wednesday, March 13, 2013 10:28 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:27 PM
Points: 7,107, Visits: 12,657
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
Post #1430741
Posted Friday, March 15, 2013 7:44 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 8:47 AM
Points: 394, Visits: 1,979
reason- for reporting purpose and to save money on license fees.
Post #1431537
Posted Friday, March 15, 2013 8:13 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:27 PM
Points: 7,107, Visits: 12,657
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
Post #1431556
Posted Friday, March 15, 2013 9:20 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 8:47 AM
Points: 394, Visits: 1,979
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.
Post #1431587
Posted Friday, March 15, 2013 9:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:27 PM
Points: 7,107, Visits: 12,657
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
Post #1431596
Posted Friday, March 15, 2013 10:52 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 8:47 AM
Points: 394, Visits: 1,979
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.
Post #1431640
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse