| 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. |
|