0

Transactional replication:

If Server A has Publisher and Distributor with SQL Server Service pack 1 and Server b is Subscriber with SQL Server 2016 service pack 2

Does publisher and distributor (SQL Server 2016) service pack 1 work with Subscriber (SQL Server 2016) service pack 2?

Improve this question

1 Answer 1

Reset to default
0

Yes, service packs and minor version differences actually don't usually matter as far as Replication compatibility is concerned. And with Transactional Replication, the requirement is that the Subscriber and Publisher be within two major versions of each other (in either direction), which the case you described is since they're both the same major version.

This is discussed in Replication backward compatibility:

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.

Improve this answer
3
  • Thank you for the information :)
    – dba_rs
    Commented Nov 18, 2022 at 6:46
  • @dba_rs No problem! If you found it helpful, feel free to accept it so others with similar questions find it verified as well.
    – J.D.
    Commented Nov 18, 2022 at 12:58
  • 1
    sure,will do.. Thanks
    – dba_rs
    Commented Nov 21, 2022 at 16:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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