In this first installment of a 2-part series, Mahesh describes and explains what Replication is, its features and benefits, and how you can put it to use.
Replication: SQL Server 2000 - Part 1 - SQL Server Platform for Replication (Page 3 of 7 )
Microsoft SQL server uses publishing industry model to represent the components and processes in replication architecture. Publishing industry publishes Magazines/Books; there are Distributors and Agents who carry these publications to the Subscribers. Subscribers of the magazine obtain copies of the publication and read the articles of interest to them; this is how the SQL Server Replication model works. Figure 1 depicts the typical Publishing industry flow.
Figure 1
Based on the above model we can identify the following Entities for the SQL Server replication model.