I currently have a published database on SQL Server 2000 that we intend to upgrade to SQL Server 2008 by detaching the database from the 2000 server and attaching it to the 2008 machine. This database is being replicated via merge replication to about
70 mobile subscribers running MSDE (2000 SP3) who aren't consistently docked and synchronized.
From my understanding of the documentation the only way to move this database and re-setup replication from 2008 down to MSDE is to delete the publication on the current SQL 2000 publisher and re-create it on the new SQL 2008 publisher. The issue is
that our subscribers aren't regularly connected and it would be very difficult to have most of them connected at the same time to push new subscriptions from the 2008 server. Deleting the SQL 2000 publication would also prevent any subscribers from uploading
changes back to the publisher database and all of that user's local work would be lost.
Is there any sort of migration path for merge replication from SQL 2000 to SQL 2008 that doesn't require the subscribers to all be connected at the same time and also prevents data loss from the subscriber's DB?
View Complete Post