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?

1 Answer 1

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.

3
  • Thank you for the information :)
    – dba_rs
    Nov 18 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.
    Nov 18 at 12:58
  • 1
    sure,will do.. Thanks
    – dba_rs
    Nov 21 at 16:04

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.