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
Author
Message
Posted Wednesday, February 6, 2013 8:48 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

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
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.
Post #1417903
Posted Sunday, February 10, 2013 7:42 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 10:37 PM
Points: 3,005, Visits: 2,606
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