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.

• Publisher
• Distributor
• Agent
• Subscriber
• Articles
• Publications
• Subscriptions

Let us further explore each of these Entities.

Next: Entities for the SQL Server Replication Model >>
 

More SQL Server Articles
More By Mahesh Kodli

Comments On: Replication: SQL Server 2000 - Part 1

· Perfect way of explaining.ThanksNarendar Piryani    · Such a beautiful way of explaining the whole repliation topic.Great Post!!!    · gr8 job...Rajendra maloo   >>> Post your comment now!