|
What are the types of Replication? Snapshot Replication
Merge Replication
Transactional Replication
Snapshot Replication
- In this kind, snapshot of entire data is copied from publisher to the subscriber's database on regular interval.
- This kind of replication is used for replicating data that doesn’t change frequently.
- It is used where the source can manage with out of date data.
- This replication is considered when amount of data to be replicated is small.
Merge Replication
- This allows both publisher and subscriber to work independently, online or offline and merges the changes later.
- Here changes are track on both publisher and subscriber and then merged.
Transactional Replication
- This kind is used when changes are frequent.
- The replication agent monitors the changes at the publisher and distributes the changes to the subscribers.
- Transactional Replication is required where up to date data is required.
|
