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

replication from 2005 to 2012 Expand / Collapse
Author
Message
Posted Tuesday, September 24, 2013 7:47 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 9, 2013 8:51 PM
Points: 2, Visits: 16
Hi everyone,

Is it possible to replicate the data from 2005 to 2012?

Thanks
Daniel
Post #1498102
Posted Tuesday, September 24, 2013 9:50 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 @ 8:49 PM
Points: 3,024, Visits: 2,628
Yes you certainly can replicate from 2005 to 2012. The distributor must be the highest version of each of the database servers participating in replication - in this case it would need to be SQL 2012.


Post #1498111
Posted Wednesday, January 8, 2014 6:25 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 6:39 PM
Points: 21, Visits: 93
Yes, you can replication from a 2012 publication to a 2005 subscriber, so long as the publication is set to have compatibility to 2005 (it will default in the setup to 2012 only).

2005 is the lowest version for 2012 support though - you can't replicate from 2012 to 2000
Post #1529173
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse