Forcing resynchronization

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lewism@bitroads.com - 31 Jan 2006 20:08 GMT

I am doing testing on a database between a SQL Server and a laptop
usingmerge replication. I can see that each system is missing a record
in each system. When i run the validation process the system
identifies that the table are not in sync. Regardless of the
resynchronization method I use the two tables do not synchronize. What
am I doing wrong

Reply to this Message

Paul Ibison - 31 Jan 2006 21:26 GMT

This sort of thing can occur if the merge trigger hasn't fired. EG

(1) If you bulk insert the rows and choose the defaults, then FIRE_TRIGGERS
is false and consequently the rows are not added to MSmerge_contents.

(2) If you do a fast-load using the Transform Data task in DTS.

In these cases case, you need to run sp_addtabletocontents to include the
rows then resynchronise. Alternatively you can use sp_mergedummyupdate for a
single row. For the fast load case, in future if you deselect the check box
the triggers will fire.

Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Reply to this Message