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.

Improve this question

1 Answer 1

Reset to default
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.

Improve this answer
2
  • Is that possible if SQL server only sends the rows which are updated or inserted for last period(which i have set) . Commented Jan 2, 2012 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. Commented Jan 3, 2012 at 14:48

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.