|
|
|
|
|
Replication Primer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Along with the various topologies, you also have complete control over the amount of information that can be distributed. The have the ability to replicate at five different levels within each of the replication topologies. These levels are as follows:
Central publisher This is one of the most common replication topologies. You would use this topology when you wanted to distribute data from a central office to various branch offices. It is also useful if you have a dual use for the same data at one location. One server can be configured for transaction processing. After the transactions are committed on one server, the data can be replicated to another server for use in decision support. This type of topology can also be used in a disaster recovery scheme to maintain a "hot spare".
Central Publisher Central subscriber This is a common topology in data warehousing. Many servers or databases replicate their data to a single central server or database.
Central Subscriber
Replication Primer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
