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, April 15, 2014 8:28 AM
Points: 38, Visits: 431
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:48 PM
Points: 2,925, Visits: 2,526
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