changing distributors

From: jsauri (jeff_sauri_at_hotmail.com)
Date: 05/06/04 

Date: 6 May 2004 12:13:14 -0700

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
and from X, all being distributed by D2.

Relevant Pages

  • Re: Configuring a remote Distributor in SQL 2005
    ... a publisher can only have one distributor so in your case your ... I have Merge Replication setup to keep everything in sync. ... SQL Server that is configured as the Publisher. ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL Server 2000 Replication Agents Credentials
    ... is used by the publisher to connect to the distributor. ... but rather the sql server agent account. ... Since this can be solved by changing the log reader job step command, ...
    (microsoft.public.sqlserver.replication)
  • Re: Inactive Publisher??????
    ... The publisher name is in ALL CAPS. ... disabling distribution on the distributor and then rebooting ... made sure the other server was set up for publication. ... I then imported data from the publisher to the subscriber so that the ...
    (microsoft.public.sqlserver.replication)
  • Domain Model/Object Design question
    ... finding the correct design pattern. ... A class "Publisher", which is a type of company with a particular ... "Manufacturer" as well, since they create books, but they do more than ... A company can be a manufacturer, publisher or distributor, or any ...
    (microsoft.public.dotnet.languages.csharp)
  • changing distributors
    ... D1 is SQL Server 2000 acting as distributor and publisher. ... also pulls subscriptions from X. ...
    (microsoft.public.sqlserver.replication)
Loading