Multiple Publishers of One Table

This scenario shows a single table that is maintained on three servers. The table is horizontally partitioned, and each server is the publisher of the data in particular rows and the subscriber to data in the remaining rows. Each server controls its own data and has a view of the other data. Stored procedures can be used to allow updates to locally owned data only.

This replication configuration might be useful, for example, for maintaining common information at regionally dispersed centers, such as warehouses or divisional offices. It could also support regional order processing.