Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I set up Replication between SQL Server 2005 and Mysql 5 using following articles :

http://ratecontrol.blogspot.com/2010/12/one-way-transactional-replication-from.html 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

1 Answer 1

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

 
discard

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.