sql server replication: I have a database (DB1) that needs to be migrated to a new
server. DB1 is involved in both a transactional
replication scheme and a merge replication scheme (all
tables except for three are trans, the other three are
merged). There are currently 10 subscriber databases on
other servers.

What would be the best way to migrate DB1 to a new server

You can do this by hacking through the replication system tables, however I
would not recommend doing this.

The two supported options by Microsoft would be to restore the SQL Server to
a machine with the same name.

The other option is to kick everyone off your publisher and subscribers, run
the merge and distribution agents to make sure all replicated commands are
applied on the publisher and subscribers, and then script and then drop the
publications and subscriptions. Backup the databases and restore them on the
new server, and then reapply the replication scripts and initialize the
subscriptions with the no-sync option.


[quoted text, click to view]