Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

SQL 2008 move merge replication - remote distributor

Avatar of Russell_Harper
Russell_HarperFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL ServerMicrosoft DevelopmentMicrosoft SQL Server 2008
3 Comments1 Solution728 ViewsLast Modified:
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.
Avatar of avbsql
avbsqlFlag of United States of America image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answers