all groups > sql server replication > september 2006 >
You're in the

sql server replication

group:

Means of checking for syncronicity between two replicated database


Re: Means of checking for syncronicity between two replicated database Paul Ibison
9/13/2006 12:00:00 AM
sql server replication: I use Redgate's DataCompare for this, but the TABLEDIFF
(http://www.replicationanswers.com/TableDiff2005.asp) utility on SQL Server
2005 will allow a similar comparison. In replication terms there is the
validation
http://www.databasejournal.com/features/mssql/article.php/1439741.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Re: Means of checking for syncronicity between two replicated database Hilary Cotter
9/13/2006 12:00:00 AM
Run a validation.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

Means of checking for syncronicity between two replicated database Methodology
9/13/2006 3:12:01 AM
Hi

what command syntax could I use to check for synchronicity between two
replicated databases? ideally id like some way to check random objects on
server A against same random objects on server B, and a way to check defined
objects - table size, amount of entries etc etc on A against B.

I can find thirsd party tools to check the syncronicity, but Id much rather
believe the SQL server itself...

ta

Alastair Jones
Re: Means of checking for syncronicity between two replicated data Methodology
9/14/2006 7:29:02 AM
Thanks All!

[quoted text, click to view]
AddThis Social Bookmark Button