While discussing replication with Jr. DBAs at work, I realize some of them have not experienced replication feature of SQL SERVER. Following is a quick reference I created for easy conversation.
The publisher is the source database where replication begins. It makes data available for replication.
The subscriber is the destination database where replication ends. It either receives a snapshot of all the published data or applies transactions that have been replicated to it.
The distributor is the intermediary between the publisher and subscriber. It receives publishing transactions or snapshots and then stores and forwards these publications to the subscribers.
The publication is the storage container for different articles. A subscriber can subscribe to an individual article or an entire publication.
An article is the data, transactions, or stored procedures that are stored within a publication. This is the actual information that is going to be replicated.
Two-phase commit is a form of replication in which modifications made to the publications database are made in the subscription database at the same time.
Let me know what you think about this short and quick article. If you like this format, I will publish more such articles on this blog in the future. The beauty of it is that it enables many users to work with their own local copy of a database but have the database updated as if they were working on a single, centralized database.
Reference: Pinal Dave (https://blog.sqlauthority.com)