Overview of Models and Strategies

There are various data replication models for replicating data.

Models include:
Other model variations and strategies you can use:

The type of application you are building, the way you update primary data, and the way you manage potential update conflicts determine the model you use to implement your replication application.

For instance, you can use the basic primary copy model to implement either a decision-support application or a low-volume distributed OLTP system. You might implement a decision-support application using either the basic primary copy model or the redistributed corporate rollup model, depending on whether your primary data is centralized or fragmented. A distributed OLTP application might be implemented using the distributed primary fragment model, with or without corporate rollup, depending on additional decision-support needs.

Related concepts
Model Variations and Strategies