Moving Database to a different Server

  • How do we move a Publisher database on SQL Server 2005 with Merge replication to a different server, without losing the replication setup

  • Its been my experience that this is not possible without reconfiguring the publication, distributor, and subscribers.

    You can script out the current configuration, but be careful! The script that generates with Management Studio doesn't always script the replication options exactly as you have them configured!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply