Skip to main content

SQL Server replication concepts

Replication Objects:
Article: Objects that will be replicated in the database.
Subscription: Object that is used for receiving updates. Each subscriber must be associated with a publisher.
Publication: Object that is used for making data available for subscribers. A publication is made of articles.

Replication Roles:
Publisher: The Publisher makes data available for subscriber.
Distributor: The Distributor is  a store for replication data associated with one or more Publishers.
Subscriber: The Subscriber receives replicated data.

Replication Types:
Snapshot Replication
Transactional Replication
Merge Replication
Heterogeneous Replication

Replication Processes:
Snapshot Agent
Log Reader Agent
Queue Reader Agent
Distribution Agent
Merge Agent


Popular posts from this blog