Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlpal2007
Posting Yak Master
200 Posts |
 Posted - 2011-07-07 : 16:26:20
|
| Hello All,At my work, transactional replication is used heavily and lot of critical reports are depending on the data residing at subscribers.We have three tier replication strategy though.server1 replicates to -> server2 replicates to ->server3.The automated reports are run on both server2 and server3.I wrote a huge code to get the table counts from these servers to check for record counts. But now we are it a point where need to know if record count is correct but what if data is off. For example quantity / Amounts / status code etc. critical fiends.How would I know what is different in publisher and subscriber data wise?Is there any tool which would do data/column compare or should I write a lengthy program to achieve this result.Please any suggestions / advice would be greatly appreciated.Thanks much,-P |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Replication data checks