top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What are different types of replication in SQL Server?

+1 vote
492 views
What are different types of replication in SQL Server?
posted Nov 22, 2014 by Vinitha

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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

  • Transactional Replication

  • Merge Replication

  • Snapshot Replication

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.

answer Nov 22, 2014 by Vrije Mani Upadhyay
...