November 14, 2007 at 3:00 am
I want only the changed rows at the publisher to be replicated to the subscriber, but it seems that all rows are replicated..
We are using 'Delete data' as 'Action if name is in use'.
Our replication failed couple of days ago, and most of the tables in our subscription database was empty. It seems like it deletes the data in all articles at the subscription in Step1. And replicated/copies data to all the tables in Step2.
Is this right?
How can we solve it?
We would like only the rows changed at the publisher to be deleted and replicated to the subscriber.
When we change the 'Action if name is in use' to 'Keep existing objects unchanged' we get duplicate keys..
/Anders
DBA at Thomas Cook
November 19, 2007 at 12:55 pm
What are you using - snapshot replication?
Consider transactional replication - you deliver a snapshot only once to sync or initialize the subscriber, after that only changes will replicate. You also have the option to use a no-sync init and make use backup/restore of publication db to init subscriber.
ChrisB MCDBA
MSSQLConsulting.com
Chris Becker bcsdata.net
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply