Go to documentation repository
Page History
Replication is the process of data coping among databases that are in the same or different servers and connected via LAN, WAN or Internet. The following terms are used in MS SQL Server replication:
Term | Description |
Publication | Server(database)that sends data to another server(database) |
Distribution | Server that controls data flow via replication system. Contains a specialized distributor database. Distribution and Publication can coincide. |
Subscription | Server(database)that receives data from the other server(database) |
Publication | Sum of articles, sent to Subscription |
Article | Main replication module: table or table's subset |
Subscription | Data group, received by Subscription |
Distribution database | System database that is saved at Distribution and doesn't contain user tables. Is used for saving the task snapshots and all the transactions, waiting for distribution by the Subscription |
| Info | ||
|---|---|---|
| ||
On default Replication service is not installed together with MS SQL Server Express. |
...
Overview
Content Tools