Merge replication deleting rows at the subscriber - 01-14-2010 , 03:07 PM
I moved a replicated database from a SQL server 2005 box to a new SQL server
2008 box. I removed the replication from 2005, backed up the database,
restored it on the new server, and then I re-setup my Merge replication
replicating to multiple SQL server 2005 Express editions. This server is a
centralized database of my other locations. I create a publication with
filters for my locations on SQL 2008 box, added my articles set the filters,
and ran the snapshot. After the snapshot was created I created a
subscription to each of the publications pointing to the proper locations
databases, and they synchronized without any conflicts or errors. After I
completed 2 of them, I noticed that the data at the locations that were not
in the centralized DB is now gone on the locations side. I checked the
properties of all articles and it is set to bidirectional.
My understanding of merge replication (or any replication for that matter)
should bring any data not in central from the location and push any data in
central that is not at the location.
Can anyone tell me what I missed here? Luckily I have my backups from
before I started so I can bring them back J, but how do I avoid this for the
Re: Merge replication deleting rows at the subscriber - 01-14-2010 , 05:15 PM
The initial part of initialization is to drop the tables on the subscribers.
Sounds like you need to amalgamate the data on the publisher before doing
Re: Merge replication deleting rows at the subscriber - 01-15-2010 , 10:46 AM
Thanks for the info, I was thinking about that. Do you think if I insert
the missing rows back in the location from my backup, they will the replicate
correctly now that the initial sych is complete?
"Paul Ibison" wrote: