Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Replication move from one server to another server Expand / Collapse
Posted Wednesday, November 6, 2013 10:11 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, November 11, 2016 12:23 PM
Points: 41, Visits: 1,215

We need to migrate databases and its replication setup to new servers.

On current environment, we have publisher,subscriber and distribution databases all on different servers but on new server setup Publisher and distributor to be on same publisher server.

Any ideas on ways to migrate replication setup?

Or only way to re-establish replication?

Thanks in advance
Post #1511939
Posted Wednesday, January 8, 2014 5:51 PM


Group: General Forum Members
Last Login: Wednesday, May 14, 2014 6:39 PM
Points: 21, Visits: 93
I've done this a large number of times. There is no "easy way" of doing it with replication in place. Basically the process is:
- Prep the new server for replication (setup the distributor)
- Get all apps using the subscriber databases offline
- Validate all subscriptions
- Resolve any validation errors
- Drop all subscriptions
- Drop the publication and disable replication on the publisher
- Backup the publisher DB
- Restore the publisher DB on the new server
- Make any changes you need on your database for and metadata relating to the old server to the new server
- Setup the publication on the new server
- Setup the subscriptions again WITHOUT INITIALISATION
Post #1529164
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse