Setup Tran Replication from 2012 to 08r2

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

    Noli Timere
  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply