question

RahulG avatar image
RahulG asked

Configure replication from SQL server 2014 Enterprise Ed. to SQL server 2017 Enterprise Ed.

The query here is pertaining to Replication support between Publisher instance running on SQL Server 2014 Ent. Ed. and Subscriber instance being on SQL Server 2017 Ent. Ed.

Currently all DB instances (Publisher, Distributor & Subscriber) are running on SQL Server 2014 Ent. Ed. But, we are undergoing migration activity where the Subscriber DB is getting upgraded to SQL server 2017 Ent. Ed. first then it is decided to configure new Distribution instance on a separate machine that will run SQL server2017 Ent. Ed. so that we can configure replication from Publisher running on SQL server 2014 Ent. Ed. , Distributor instance running on SQL server 2017 Ent. Ed & Subscriber instance running on SQL server 2017 Ent. Ed.

Now, in this migration activity we are trying to identify an approach that will help us to configure replication from Publisher instance(SQL 2014 Ent. Ed.) to the newly created Distributor instance(SQL 2017 Ent. Ed.) without hampering the existing replication setup.

Also We would like to know is there any other way to achieve this or issues that could arise due to this approach ?

Note: We have excluded below options: 1) Upgrade Publisher or Distributor DB instance to SQL 2017 Ent. Ed.

sql-serverreplicationdatabasemigration
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.