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

Find and replace with sed command in Linux

Find and replace feature is always handy. It can turn into a torture when it comes to change or delete a simple constant string in a text file. There is a handy tool in linux for doing these kind of tihngs. Actually sed is not a text editor but it is used outside of the text file to make changes.