Replication Terminology Understanding

Replication in SQL Server, copying and distributing data and database objects from one database to another, and then synchronizing between databases to maintain consistency. Replication is focused on data synchronization, it doesn ' t distribute entire database, but only distributes some part of the database like tables or views 。

1,publisher Publishing Server

Publisher is a data source that provides replication database objects

2,subscriber Subscriber Server

Subscriber is a DB instance that receives replication, subscriber can receive data from multiple publisher.

3,article Project

Article are objects in a database, which can be database objects such as tables, view,stored procedure,function, and one or more aritcle collections form a publication.

You cannot pass a article alone, you must include article in publication to be used for replication.

4,publication Release

Publication is the basic unit for replication, and the basic unit for transferring data between Publisher and Subscriber is publication, not tables, view,stored procedure, and other database objects.

Publication is a collection of one or more article, and a publication can contain different types of article.

5,subscription Subscription

Subscription is sending publication from Publisher to Subscriber, depending on the way it is sent, there are two types of subscription: Push subscription and pull subscription

Features of Push subscription:

With this subscription, the publisher was responsible for updating all the changes to the Subscriber without the Subscriber Asking those changes, Push subscriptions is created at the Publisher server.

Features of Pull subscription:

With this subscription the subscriber initiates the replication instead of the publisher, the subscriptions is created at The subscriber server.

6,distributer distribution Server

Distributer is a database instance that serves one or more publisher. Each publisher corresponds to a database in Distributer, which is called the distribution database. The distribution database holds replication state information and metadata for each publication.

7,replication Agent

Replication Terminology Understanding