February 6, 2013 at 8:48 am
We are planning to do a side by side upgrade of a prod server. We have replication configured on it. I would like to stop replication when all the transactions are passed on to subscriber. I will be disabling all the logins and jobs, before we stop replication. How to know the data is in sync at both publisher and subscriber?
February 8, 2013 at 2:04 pm
Hi,
There are several ways to do it. I use our Redgate SQL Compare to see the data between primary and secondary are identical or not. RedGate SQL Compare is a great way to compare objects between two databases. You can even download and run a trial before suggesting your business to buy one for you...;-)
Hope this will help.
February 10, 2013 at 7:42 pm
Replication comes with a utility called "tablediff" - could be what you need. You will find it in a folder something like
C:\Program Files\Microsoft SQL Server\110\COM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply