|
What is Replication in SQL Server?- Replication allows creating copies of data in separate databases along with keeping all databases synchronized by replicating modification in one copy to all the copies.
- Data can be effectively distributed over network using replication.
- It is a set of technologies for copying and distributing data and database objects from one database to another.
Replication is following three types:
1. Transaction replication
2. Merge replication
3. Snapshot replication
- These types of replication you can choose for an application which depends on many factors like physical replication environment.
1. Transaction replication:
- It is mostly used in server-to-server scenarios which require high throughput, improving scalability and availability.
- It starts with a snapshot of the publication database objects and data.
2. Merge replication:
- It starts with a snapshot of the publication database objects and data.
- It is used in server-to-client environments.
3. Snapshot replication:
- It provides the initial data set for transactional and merge replication.
- It has a lower continuous overhead on the publisher than transactional replication because incremental changes are not tracked.
|
