The Central Subscriber Replication Model
In the central subscriber scenario, as shown in Figure 19.13, several publishers replicate data to a single, central subscriber. Basically, this supports the concept of consolidating data at a central site. An example of this might be consolidating all new orders from regional sales offices to company headquarters. In such a situation, you now have several publishers of the Orders
table, and you need to take some form of precaution, such as filtering by region. This would guarantee that no one publisher could update another region’s orders.
Get Microsoft® SQL Server 2008 R2 Unleashed 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.