Question on Data out of sync

I'm not too sure if it is relevant, but to ensure that
deletes on the publisher don't go to the subscriber, the
synctype is set to NONE.
To check that the data is in sync, you can use validation
(right-click on the publication and select validate
subscriptions. One option here is to use a
binary_checksum, and this is the same function you can
use to compare the publisher and subscriber tables using
linked servers in order to manually synchronize the
tables. Having said that, I'd say that most people just
reinitialize to sort out the issue.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Paul,
Could you please expand on this. I am not completely sure I understand
how to do what you are talking about. I tried looking up references to
the checksum function but could not tell how to use it to make it fit
this situation.
Thanks for the info!
MM
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Mike,
you could use
Data Compare from Red Gate. Cheap, easy and works well.
http://www.red-gate.com/SQL_Data_Compare.htm
Checksum can be used but is not 100% sure to succeed.
select * from newEmp A
Inner Join oldEmp B on
A.empId = B.empId
where checksum(a.*) <> checksum(B.*)
Rgds,
Paul Ibison