Migrate merge replication from a server with SQL Server 2000 to another server SQL Server 2008

Question

I have a cluster server with SQL Server 2000 SP1 Enterprise. This server is distributor and publisher of 2 databases (about 40 subscribers with MSDE 2000 SP4).
I have to change the old server with a new one (Windows Server 2008 Enterprise + SQL Server 2008 Std).
What is the best way to migrate the replication considering that the applications running on subscribers use their local DB and they need to update quickly the data between other subscribers?

Many thanks for your help.
Marco

 

Answer 1

Hello,

Please see the following article:

http://technet.microsoft.com/en-us/library/ms143699.aspx

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com