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
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)
Monday, March 26, 2012
Forcing resynchronization
Labels:
database,
forcing,
laptopusingmerge,
microsoft,
missing,
mysql,
oracle,
recordin,
replication,
resynchronization,
server,
sql,
system
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment