Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

side by side upgrade-replication cut over Expand / Collapse
Posted Wednesday, February 6, 2013 8:48 AM


Group: General Forum Members
Last Login: Tuesday, July 15, 2014 8:13 PM
Points: 124, Visits: 750
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?
Post #1416560
Posted Friday, February 8, 2013 2:04 PM

SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 7:20 AM
Points: 38, Visits: 432
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.
Post #1417903
Posted Sunday, February 10, 2013 7:42 PM


Group: General Forum Members
Last Login: Yesterday @ 9:10 PM
Points: 2,995, Visits: 2,592
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

Post #1418188
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse