views:

22

answers:

0

I have a server with about 3 replications configured.

  • 3 databases being published to about 3 other servers
  • there's a central Distributor

I need to know if I can change the distributor for one of the publishings and let the others or if I can only change all of the replication distributors at the publisher server.

And How to do this.

Example:

ProdServer has

  • DB1 - Publishing
  • DB2 - Publishing
  • DB3 - Publishing

DB1ReplSrv has

  • DB1 - Subscribing

DB2ReplSrv has

  • DB2 - Subscribing

DB3ReplSrv has

  • DB3 - Subscribing

RplDistSrv is the distributor for all of this.

Let's say I create a new server: NewRplDistSrv I wan't slowly change the replications distributor server.

PS:I don't know if it's a Pull or Push Replication, how do I check this?

Sorry for my noobish question. But I would like to learn.

Thanks in advance,

Gabriel