7

Does the subscriber "within two version requirement" for transactional replication from this MSDN article apply to the SQL Server Instance, Database Compatibility Level, or Both?

For example, would replication work with this environment setup?

  • Publisher and Subscriber SQL Instance: SQL Server 2014 Enterprise Edition 64-bit (12.0)
  • Distributor Database Compatibility Level: 110
  • Publisher Database Compatibility Level: 110
  • Subscriber SQL Instance: SQL Server 2017 Enterprise Edition 64-bit (14.0)
  • Subscriber Database Compatibility Level: 140
Improve this question
2
  • 1
    I don't know, but do you have an explicit issue with upgrading your compatibility level? It is generally advised to keep it beneath the server version only as a temporary measure during upgrades.
    – LowlyDBA - John M
    Oct 31, 2018 at 19:05
  • The application that uses the Publisher Database does not support compatibility levels greater than 110, so I cannot upgrade the compatibility of the Publisher database. However, I have a need to upgrade the Subscriber Instance and database, and I'd like to upgrade to 2017 if possible.
    – jhase511
    Oct 31, 2018 at 19:36

1 Answer 1

Reset to default
5

Does the subscriber "within two version requirement" for transactional replication from this MSDN article apply to the SQL Server Instance, Database Compatibility Level, or Both?

Yes. No. No.

The database compatibility level is irrelevant, and you would never set the database compatibility on the distribution database, as it's a system database.

A SQL Server 2014 publisher/distributor can have a SQL Server 2017 subscriber.

SQL Server 2017 supports compatibility levels back to 100, so you can set the subscriber database to 110 compatibility level if you want to. And you might need to if you publish views, stored procedures, stored procedure executions, or have triggers on subscriber tables that aren't NOT FOR REPLICATION.

Improve this answer
1
  • The only downside can be that the bcp files created by the publisher may not necessarily be compatible. But the solution is straightforward.
    – clifton_h
    Nov 1, 2018 at 0:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.