The Publisher, Distributor, and Subscriber Metaphor
Any SQL Server can play up to three distinct roles in a data replication environment:
As a Publication server (the publisher of data)
As a Distribution server (the distributor of data)
And, as a Subscription server (the subscriber to the data being published)
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 7.4, the Customers table in the Northwind database is the data to be published. To publish data, the database that contains the data must first be “enabled” for publishing. Full publishing configuration requirements will be discussed later in this chapter in the “Setting ...
Get Microsoft® SQL Server High Availability 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.
