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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.