November 6, 2013 at 10:11 am
Hi
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
January 8, 2014 at 5:51 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply