I have a client who's SQL Server is being used as a OLTP database server and a distributor to 42 subscribers using merge replication. Each of the 42 subscribers are running SQL 2008 R2 Express so can only subscribe to a push publication.
The client is looking to purchase a new server and migrate the OLTP database to it and the plan is to use the existing server as a remote distributor (all the data that is replicated resides in the OLTP database). The idea here is to reduce the amount of work the OLTP server is doing. Is it possible to migrate replication without having to set it up from scratch again? The volume of data that needs to be replicated means there isn't a long enough window to reapply new snapshots to the subscribers should this be the case.
Just to recap:
In the currency scenario they have SERVER1. This is the OLTP server and distributor.
In the new scenario they have a new server SERVER2. This will be the OLTP server and SERVER1 will be the remote distributor for replication.
Any advice would be appreciated.