June 10, 2016 at 8:49 am
Hi everyone,
We have set up Transactional Replication in our work environment (SQL Server 2014) and replicate data onto our system from 4 different sources.
We would like to have a better grip on the replication process and would like a validation / recon job to run everyday and publish a report comparing source to destination rowcount and last updated datetime for the few tables we are interested.
What is the best way to do this?
1. Create an SSIS package to generate comparison data and store in a table?
2. How about using Replication Stored Procedures like sp_articleview, sp_table_validation etc.? Would someone be able to help me understand how to use these if this is a good approach?
https://technet.microsoft.com/en-us/library/ms174364(v=sql.105).aspx
Thanks for your time!
Rahul
June 11, 2016 at 3:38 pm
Please check this article from books online. As you've mentioned, you can certainly take either of the route, but my preferred way would be to use tablediff utiity.
https://msdn.microsoft.com/en-us/library/ms151752(v=sql.120).aspx
Regards,
Fievel
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply