|
Data Replication. Create a replication set and replication link that move data between two locations. A high-level pattern that describes the general process of the more detailed Data Movement Patterns described in this table. See "Data Replication" at http://msdn.microsoft.com/en-us/library/ms978671.aspx.
Master-Master Replication. Copy data from the source to the target and detect and resolve any update conflicts that have occurred since the last replication (due to changes to the same data on the source and target). The solution consists of a two replication links between the source and the target in opposite directions. Both replication links transmit the same replication set in both directions. Such a pair of replication links is referred to as related links. See "Master-Master Replication" at http://msdn.microsoft.com/en-us/library/ms978735.aspx.
Master-Subordinate Replication. Copy data from the source to the target without regard to updates that may have occurred to the replication set at the target since the last replication. See "Master-Subordinate Replication" at http://msdn.microsoft.com/en-us/library/ms978740.aspx.
Master-Master Row-Level Synchronization. Use a pair of related replication links between the source and target and a synchronization controller to manage the synchronization in both directions. To synchronize more than two copies of the replication set, create the appropriate replication link pair for each additional copy. See "Master-Master Row-Level Synchronization" at http://msdn.microsoft.com/en-us/library/ms998434.aspx
Master-Subordinate Snapshot Replication. Make a copy of the source replication set at a specific time (this is known as a snapshot), replicate it to the target, and overwrite the target data. In this way, any changes that might have occurred to the target replication set are replaced by the new source replication set. See "Master-Subordinate Snapshot Replication" at http://msdn.microsoft.com/en-us/library/ms998430.aspx.
Capture Transaction Details. Create additional database objects, such as triggers and (shadow) tables, and record changes of all tables belonging to the replication set. See "Capture Transaction Details" at http://msdn.microsoft.com/en-us/library/ms978709.aspx.
Master-Subordinate Transactional Incremental Replication. Acquire the information about committed transactions from the source and replay the transactions in the correct sequence when they are written to the target. See "Master-Subordinate Transactional Incremental Replication" at http://msdn.microsoft.com/en-us/library/ms998441.aspx.
Master-Subordinate Cascading Replication. Increase the number of replication links between the source and target by adding one or more intermediary targets between the original source and the end target databases. These intermediaries are data stores that take a replication set from the source, and thus act as a target in a first replication link. They then act as sources to move the data to the next replication link and so on until they reach the cascade end targets. See "Master-Subordinate Cascading Replication" at http://msdn.microsoft.com/en-us/library/ms978712.aspx.
|