1

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.

Community
  • 1
Abdullah Khatri
  • 11
  • 1

1 Answers1

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.

mrdenny
  • 27,174
  • 4
  • 41
  • 69
  • 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 02 '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 03 '12 at 14:48