What is Replication ?
Replication is the mechanism for creating and maintaining multiple copies of the same data. Replication allows,
• Multiple copies of data can be kept in sync.
• Allows data be closer to users, improving performance.
• Allows a branch office to work when not connected to the main office.
• Separate process and offload work from production servers
What are the Components of Replication
Following are the important components in replication setup
• A publication contains articles.
• The publisher either distributes the magazine directly or uses a distributor.
• Subscribers receive publications to which they have subscribed.
What are the Server Roles Involved in Replication ?
SQL Servers can be assigned three different roles in a replication topology:
• Publishers create and modify data.
• Distributors store replication-specific data associated with one or more publishers.
• A subscriber holds a replica copy of the data.
What are the type of replication available in SQL Server ?
SQL Server supports
- Snapshot replication sends the entire data set to the subscriber.
- Transactional replication only sends modifications to the data.
- Merge replication items are modified at both the publisher and subscribers.
- Heterogeneous replication allows access to other database products.
- Peer to Peer Transactional Replication