Replication MySQL & MS SQL

Question

How make replication between MySQL and MS SQL server 2005. I want flow data from MySQL to MS SQL server, when ever any changes makes in MySQL.

Thank you,

Asik · Accepted Answer · 2014-04-08 08:30:25Z

1

Try symmetricDS http://www.symmetricds.org/. it is supporting DB sync between different DB and ofcourse, it is supporting MySql & MsSql sync.

you can study and set the configuration as per your needs. it can support the following sync

One way sync - this option is supposed for your case
Two way sync

edited Apr 8, 2014 at 8:30

answered Apr 8, 2014 at 8:12

Asik

7,9674 gold badges30 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dave · Accepted Answer · 2011-01-21 22:45:47Z

0

Creating a SSIS procedure to do this is not difficult if you're willing to do it as a "batch" process. Replicating in real-time has caused our SQL Server to burp big time. We now do a nightly process that copies the data from one server to the other.

answered Jan 21, 2011 at 22:45

Dave

1,24413 silver badges24 bronze badges

Comments

Community · Accepted Answer · 2015-08-20 04:40:52Z

0

I'm not a fan of linking to external resources wholesale, but there's a TechRepublic blog that implements this exact feat, although it's decidedly non-trivial.

Then again, this is (quite frankly) a bit of an unusual requirement.

edited Aug 20, 2015 at 4:40

CommunityBot

11 silver badge

answered Jan 21, 2011 at 17:16

John Parker

54.5k11 gold badges133 silver badges131 bronze badges

Collectives™ on Stack Overflow

Replication MySQL & MS SQL

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related