Replication Scenarios

In general, depending on your business requirements, one of several different data replication scenario models can be implemented. These include the following:

  • Central publisher

  • Central publisher with a remote distributor

  • Publishing subscriber

  • Central subscriber

  • Multiple publishers or multiple subscribers

  • Updating subscribers

Central Publisher

The central publisher replication model, as shown in Figure 7.11, is Microsoft's default scenario. 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 2000, SQL Server 7.0, and Oracle.

Figure 7.11. The central publisher ...

Get Microsoft® SQL Server High Availability 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.

Start your free trial