Migrating SQL Server replication from one server to another

Tags:
SQL Server migration
SQL Server replication
We are migrating our SQL Server from one server to another; is there a way that replication can also be moved from source to destination?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Yes, sort of. The easiest way is to simply resetup the replication.

If you don’t like that answer…

Backup the publishing database and restore it to the new publisher with the KEEP_REPLICATION flag enabled.

Go to the subscribers and update the dbo.syssubscription tables with the new publishers information.
Update the subscription tables with the new publisher information. Edit all the jobs on the distributor to point to the new publisher.
Update the tables in the distributor to point to the new distributor.

If you don’t like that answer…

The easiest way to do all of this is to stop SQL on the old server, copy all the system and user databases to the new SQL Server overwritting the system databases, then rename the new SQL Server so that it has the same name as the old server. Then bring SQL on the new server online and it everything should fire right back up.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: