We have a big challange here.
We are running SQL2000 here with a merge replication to SQL2000 Servers.
Let me describe at follows.
D_exist = Distributor SQL 2000
D_new = Distributor SQL 2005
S1-5 = Subscriber
The database is around 10GB. The bandwith between the D*+S is at max about 512kB, so not the best speed.
Well now the D_exist is on old Hardware situated, and we have to move the server to other hardware. We have installed a new server as D_new. That Server is also up and running. Well, now we have to migrate that particular database from D_exist to D_new. How can we do that?
Is it possible to:
- stop the replication
- delete publication and delete all subscriptions
- move the DB to D_new
- create a new publication
- tell the server that all the date on the subscribers are available (and if yes, how)
- start the replication
are there other possibilities to move such a replication without copy the snapshot.