Setup Tran Replication from 2012 to 08r2

• saqlainkhan

  Ten Centuries

  Points: 1126

  More actions

  March 26, 2013 at 8:56 am

  #291575

  Is it possible to setup replication from SQL 2012 (Pub) to 08r2 (Sub)

  Noli Timere

• Kumari Punam

  SSC Journeyman

  Points: 79

  More actions

  March 27, 2013 at 4:15 am

  #1601066

  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.