The Central Publisher Replication Model
The central publisher replication model, shown in Figure 43.10, is Microsoft’s default scenario and a common model used if your primary server has plenty of spare CPU cycles and you want a simple replication model. In this scenario, one SQL Server performs the function of both publisher and distributor. The publisher/distributor can have any number of subscribers. These subscribers can come in many different varieties, such as SQL Server 2014, SQL Server 2008/R2, and Oracle.
FIGURE 43.10 The central publisher scenario is fairly simple and is the replication model used most often.
The central publisher ...
Get Microsoft SQL Server 2014 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.
