side by side upgrade-replication cut over

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » side by side upgrade-replication cut over

side by side upgrade-replication cut over

Rate Topic

Display Mode

Topic Options

Author

Message

deep_kkumar

Posted Wednesday, February 06, 2013 8:48 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 9:28 AM
Points: 94, Visits: 560

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

SqlSWAT

Posted Friday, February 08, 2013 2:04 PM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 11:31 AM
Points: 38, Visits: 336

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... Wink

Hope this will help.

Post #1417903

happycat59

Posted Sunday, February 10, 2013 7:42 PM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 10:54 PM
Points: 2,467, Visits: 2,059

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 »

Permissions