What Is Data Replication?
In its classic definition, data replication is based on the ”store and forward” data distribution model, as shown in Figure 7.2. Data that is stored in one location (inserted) is automatically “forwarded” to one or more distributed locations.
Figure 7.2. Store and forward distribution model.
Of course, a more complete data distribution model would address updates, deletes, data latency, and autonomy for data and schemas. It is this data distribution model that Microsoft's data replication facility serves to implement. There are three primary scenarios for using data replication:
The first, as you can see in Figure 7.3 ...
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.
