Is possible to Use Replication between 2 different SQL Versions?



  • I have Database SQL Server 2016 on server , and other Database SQL Server 2019 standard edition in another server. is that possible to use replication and pass data from 2016 to 2019?



  • Yes. See the https://docs.microsoft.com/en-us/sql/relational-databases/replication/tutorial-preparing-the-server-for-replication?view=sql-server-ver15 on the https://docs.microsoft.com/en-us/sql/relational-databases/replication/tutorial-preparing-the-server-for-replication?view=sql-server-ver15#prerequisites section of the doc:

    That other reference doc says:

    Backward compatibility is important to understand if you are upgrading, or if you have more than one version of SQL Server in a replication topology.

    The general rules are:

    • A Distributor can be any version as long as it is greater than or equal to the Publisher version (in many cases the Distributor is the
      same instance as the Publisher).

    • A Publisher can be any version as long as it less than or equal to the Distributor version.

    • Subscriber version depends on the type of publication:

      • A Subscriber to a transactional publication can be any version within two versions of the Publisher version. For example: a SQL
        Server 2012 (11.x) Publisher can have SQL Server 2014 (12.x) and
        SQL Server 2016 (13.x) Subscribers; and a SQL Server 2016 (13.x)
        Publisher can have SQL Server 2014 (12.x) and SQL Server 2012
        (11.x) Subscribers.
      • A Subscriber to a merge publication can be all versions equal to or lower than the Publisher version which are supported as per the versions life cycle support cycle.

Log in to reply
 


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2