The Publisher, Distributor, and Subscriber Metaphor
Any SQL Server can play up to three distinct roles in a data replication environment, as represented in Figure 22.3:
Being a publication server (the publisher of data)
Being a distribution server (the distributor of data)
Being a subscription server (the subscriber to the data being published)
Figure 22.3. The publisher, distributor and subscriber.
The publication server contains the database or databases that are going to be published. This is the source of the data that is to be replicated to other servers. In Figure 22.3, the Customers table in the Northwind database is the data to be published. ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
