1.

What Are Publisher, Distributor And Subscriber In “replication”?

Answer»

Publisher: A publisher is any database UNIT that makes data available to other sources via replication. The publisher can have MULTIPLE publications which defines the data to replicate.

Subscriber: A subscriber is any database unit that receives the REPLICATED data. It can receive data from multiple publishers or publications. Data can be republished to the other subscriber.

Distributor: A distributor is any database unit that acts as a store for the data to be replicated. Each publisher is associated with a SINGLE database called as distribution database. Replication status data is stored in distribution database. A distributor can be local or remote.

Publisher: A publisher is any database unit that makes data available to other sources via replication. The publisher can have multiple publications which defines the data to replicate.

Subscriber: A subscriber is any database unit that receives the replicated data. It can receive data from multiple publishers or publications. Data can be republished to the other subscriber.

Distributor: A distributor is any database unit that acts as a store for the data to be replicated. Each publisher is associated with a single database called as distribution database. Replication status data is stored in distribution database. A distributor can be local or remote.



Discussion

No Comment Found