changing distributors -- sql server replication

jeff_sauri NO[at]SPAM hotmail.com
5/6/2004 12:13:14 PM

Is it possible to change the distributor for a publisher without
affecting the publications?

Example:

D1 is SQL Server 2000 acting as distributor and publisher. X is SQL
Server 7.0 acting as a publisher. D1 pushes subscriptions to X and
also pulls subscriptions from X.

D2 is SQL Server 2000 and needs to act as the distributor, as well as
publisher. X is registered as a publisher with D2.

So here's the problem. I want D1 to continue pushing and pulling
subscriptions to and from X. However, I want D2 to be the distributor
for it. I don't care if D1 remains as a distributor or not. The
result should be that both D1 AND D2 push and pull subscriptions to

Hilary Cotter
5/6/2004 10:06:01 PM

There is no supported way of doing this. You have to drop your publications,
make your change, recreate your publications and subscriptions.

[quoted text, click to view]

sql server replication : changing distributors