validate data

Question

validate data

ramyours2003

SSChampion

Points: 12268
More actions
May 20, 2014 at 7:56 am

#291497

i configured replication , how to validate the data whether the publisher and subscriber are both in sync ?

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

free_mascot One Orange Chip Points: 27164 More actions · Answer 1

You can check the status in Replication monitor

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

ramyours2003 SSChampion Points: 12268 More actions · Answer 2

thanks for the reply How to check in monitor and is any query to run in the pub\subscriber to validate ?

SQL Guy 1 SSCoach Points: 15981 More actions · Answer 3

I usually run this query on both sides and monitor its progress. It would be helpful if you have two monitors

select SCHEMA_NAME = left(s.name,30),

table_name = left(t.name,80),

records = i.rows

from sys.schemas s

join sys.tables t on s.schema_id = t.schema_id

left join sys.sysindexes i on t.object_id = i.id

and i.indid in (0,1)

order by i.rows desc