Central Subscriber

In this scenario, a number of publication servers replicate information into a common destination table. The destination table is horizontally partitioned and contains a location-specific column as part of the primary key. Each publication server replicates rows containing location-specific data.

This replication configuration might be useful, for example, for rolling up inventory data from a number of servers at local warehouses into a central subscriber at corporate headquarters. It could also be used to roll up information from autonomous business divisions within a company, or to consolidate order processing from dispersed locations.