In current setup we have replication configured with Subscriber as SQL 2014 and Publisher as SQL 2008. We are planning to upgrade it to SQL 2019 and SQL 2016 respectively. And In subscriber server we are planning to set the DB compatibility as 100

Question

In current setup we have replication configured with Subscriber as SQL 2014 and Publisher as SQL 2008. We are planning to upgrade it to SQL 2019 and SQL 2016 respectively. And In subscriber server we are planning to set the DB compatibility as 100.

Is there any issues configuring replication as above since we are setting the DB compatibility as 100 in subscriber server.

Answer 1

Hi,

I guess there is no issue, you may have compatibility as 100 (for SQL Server 2016 or 2019).

Please go through below links to have better idea:

https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-ver16&redirectedfrom=MSDN

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades?view=sql-server-ver16&source=recommendations

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2019?view=sql-server-ver16&source=recommendations

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-replicated-databases?view=sql-server-ver16

Regards,

Answer 2

Hi，Ambily Jose

I guess you might also configure the publishing database as a distribution database.

SQL Server 2019 (as a Subscriber)

SQL Server 2016 (as Publisher and Distributor)

Meets the requirements of the Replication Matrix.

SQL2019 supports compatibility level 100. Therefore, there are no issues with the choices and configuration you mentioned above.

However, by setting the compatibility level to 100, you will be running the database with behaviors from SQL Server 2008. This means you will not have some new features or performance enhancements from SQL Server 2019.

For specific limitations, please refer to [Differences between compatibility levels](https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-ver16&redirectedfrom=MSDN#differences-between-compatibility-levels

).

Best Regards,

Mikey Qiao

---

If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.