data-konzept

'Problem

We had a requirement to move the Subscriber for a Merge publication to a new SQL Server. We could have dropped the old subscriber and created a new subscriber, but in this tip we look at another option.

Solution

In this tip we will look at how this can be done by restoring a full backup of the existing subscriber onto the new server and altering a few replication tables without having to drop the old subscription and create a new subscription.'...

https://www.mssqltips.com/sqlservertip/4279/move-sql-server-merge-replication-subscriber-to-new-server-without-reconfiguring-replication/