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