Central Publisher

SQL Replication

Replication

Central Publisher

The simplest Microsoft® SQL Server™ 2000 replication topology model places one Publisher and one Distributor on the same server and one Subscriber on a separate server.

The scenario becomes more complex as you add Subscribers to the Publisher and Distributor. The Publisher owns the data being published and becomes a central Publisher for all the Subscribers. For example, this scenario might be used to distribute master data, lists, or reports from a central Publisher to any number of Subscribers.

The roles of Publisher and Subscriber are not exclusive; servers can perform both simultaneously. For example, suppose Server A publishes Publication 1, and Server B publishes Publication 2. In this case, Server A could act both as a Publisher of Publication 1 and a Subscriber to Publication 2. This is an example of filtering data and publishing partitions.