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

Can I migrate a publisher to 2012 and have it continue to replicate to 2008R2 Subscriber without missing a beat Expand / Collapse
Author
Message
Posted Friday, July 12, 2013 7:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 3:29 PM
Points: 11, Visits: 109
I will be migrating our Production DB to SQL 2012 shortly (no service interruption using mirroring from 2008R2 to 2012). that part works well.

But our Production DB is a publisher feeding a Reporting DB and I'm not clear if replication can pick up from where it left off after the migration or whether I have to re-build the publication / Snapshot from scratch and whether I can continue to use the existing 2008R2 distributor or have to switch to a 2012 distributor. Either way I would like to know the prescribed upgrade method from some experts who have given this a shot.

Are there good articles (advice) on the subject?

I'd rather not have to fully re-build the Transaction publication but could do that (including the lengthy snapshot) if that is the best/safest approach.

In which case I might just re-configure the whole lot now to a 2012 Distributor now and make the new subscriber Reporting database a 2012.

Thoughts?

...Ray
Post #1473033
Posted Friday, July 12, 2013 11:40 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:05 PM
Points: 33,165, Visits: 15,299
The distributor must be the highest version. then publisher, then subscriber.

http://msdn.microsoft.com/en-us/library/ms143699.aspx







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1473172
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse