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

Setup Tran Replication from 2012 to 08r2 Expand / Collapse
Author
Message
Posted Tuesday, March 26, 2013 8:56 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, October 31, 2014 9:58 AM
Points: 40, Visits: 379
Is it possible to setup replication from SQL 2012 (Pub) to 08r2 (Sub)





Noli Timere
Post #1435554
Posted Wednesday, March 27, 2013 4:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 15, 2014 1:52 AM
Points: 5, Visits: 94
Yes, it is possible.
For all types of replication, the Distributor version must be no earlier than the Publisher version. Frequently, the Distributor is the same instance as the Publisher.

For transactional replication, a Subscriber to a transactional publication can be any version within two versions of the Publisher version. So if your publisher is of 2012 version, then your subscriber can be of 2008 and 2008R2.
Post #1435813
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse