Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I set up Replication between SQL Server 2005 and Mysql 5 using following articles : and error setting up replication from mssql to mysql

It works fine... but there is a problem that it sends all the rows from tables from my sql server 2005 publication to mysql . I just want it send the differences between the tables of publisher to the mysql subscriber. Please help ASAP.

share|improve this question

Replication will by default send all the rows in the table. SQL Replication won't merge the tables on the publisher and the subscriber.

share|improve this answer
Is that possible if SQL server only sends the rows which are updated or inserted for last period(which i have set) . – Abdullah Khatri Jan 2 '12 at 18:34
If you put a filter on the publication, and then did some editing of the stored procedures that replication creates on the subscriber you could probably get that working. Not sure if that'll work as expected when replicating to MySQL or not. You might need to replicate to another SQL Server database first, then replicate that database to the MySQL server. – mrdenny Jan 3 '12 at 14:48

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.