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

Ambily Jose 25 Reputation points
2024-06-27T14:53:01.0833333+00:00

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,268 questions
{count} vote

Accepted answer

1 additional answer

Sort by: Most helpful
  1. MikeyQiaoMSFT-0444 1,750 Reputation points
    2024-06-28T08:38:48.55+00:00

    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.

    1 person found this answer helpful.
    0 comments No comments