We have a merge replication setup among seven servers. I have found some replication issue, mainly mismatch data between Publisher and 2 subscriber. I also noticed that merge agent at subscriber was stopped & started. Now the data is not getting synchronized among those 2 subscriber and the publisher. I checked the Replication Monitor, Replication cannot get past the ‘connecting to subscriber “X”’ message.
Now i need to synchronize the data, before doing that i thought to get a second opinion from you guys. Since i don't want to have any data loss at the subscriber or at publisher, so i cannot reinitialize the synchronization. My options are - track out mismatch records using tablediff and do a manual delete insert at the publisher. Another option is to use Redgate SQL Data Compare, and synchronize tables on both publisher and subscriber.
Please guide me if am wrong at any point or if there are many other better option available.
asked Feb 13 '11 at 10:09 PM in Default
Using Redgate SQL Data Compare could be a good idea, but remember that you will need a decent connection between the two servers as a lot of data may need to flow.
You can also tell a subscriber to reinitialise and upload changes to the publisher first. When you try to initialise through the GUI the question pops up
answered Feb 13 '11 at 11:57 PM