change sql ce merge replication servers

I have about 115 sql ce databases syncing to about 100 sql databases. The
sql databases are all on the same server. We want to move the sql databases
to a new server without any data loss. Does anyone have any good ideas on
how to accomplish this or links to resources about this kind of thing?
Thanks, Scott
I think you will need to create the new publications and then push the new
program doing the pull to the SQL CE devices with the updated publisher
information.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Scott S." <ScottS@.discussions.microsoft.com> wrote in message
news:7100354D-4314-46D2-A937-9D5D1964A0DD@.microsoft.com...
>I have about 115 sql ce databases syncing to about 100 sql databases. The
> sql databases are all on the same server. We want to move the sql
> databases
> to a new server without any data loss. Does anyone have any good ideas on
> how to accomplish this or links to resources about this kind of thing?
> Thanks, Scott
|||Here's what I got working: Stop clients from syncing, create a backup of the
databases to be switched, restore the backup to the new server and create the
publications, the last step is to reinitialize the subscriptions with upload
set to true.