How make replication between MySQL and MS SQL server 2005. I want flow data from MySQL to MS S开发者_开发技巧QL server, when ever any changes makes in MySQL.
Thank you,
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
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.
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.
精彩评论