Changing the Distribution Database That a Publisher Uses

To change the distribution database that a Publisher uses, and assign another distribution database, essentially involves starting over. You perform several operations at the Distributor:

• Disable the Publisher.

  This automatically deletes all publications, articles, and subscriptions that are dependent on the Publisher.

• Remove the Publisher from the distribution database.
• Enable the publishing server as a new Publisher with a different distribution database.

These operations must be performed at the Publisher:

• Create the publications and articles to be published on the publishing server.
• Enable the Subscribers that can receive data from the Publisher.

To remove a Publisher

To enable a Publisher