Share via

Types of Replication

Microsoft SQL Server 2005 provides the following types of replication for use in distributed applications:

The type of replication you choose for an application depends on many factors, including the physical replication environment, the type and quantity of data to be replicated, and whether the data is updated at the Subscriber. The physical environment includes the number and location of computers involved in replication and whether these computers are clients or servers. For more information about determining the type of replication best suited to a particular application, see Implementation Considerations for Replication in SQL Server 2005 Books Online.

Each type of replication typically begins with an initial synchronization of the published objects between the Publisher and Subscribers. This initial synchronization can be performed by replication with a snapshot, which is a copy of all of the objects and data specified by a publication. After the snapshot is created, it is delivered to the Subscribers. For some applications, snapshot replication is all that is required. For other types of applications, it is important that subsequent data changes flow to the Subscriber incrementally over time. Some applications also require that changes flow from the Subscriber back to the Publisher. Transactional replication and merge replication provide options for these types of applications.

Data changes are not tracked for snapshot replication. Each time a snapshot is applied, it completely overwrites the existing data. Transactional replication tracks changes through the SQL Server transaction log, and merge replication tracks changes through triggers and metadata tables.

See Also


Replication Components
Replication Considerations (SQL Server Express)

Help and Information

Getting SQL Server 2005 Assistance