What is replication and types of replication?

What is replication and its types?

Types of Replication: 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.

How many types of replication are there?

There are four MS SQL Server replication types: snapshot replication, transactional replication, peer-to-peer replication and merge replication.

What is it replication?

Replication is the process of copying data from a central database to one or more databases. The central database is called the publication database because it provides the data for users at other sites. The data in the publication database is copied (replicated) to subscription databases at other locations.

What are the forms of replication?

What are the types of data replication?Full-table replication. ... Snapshot replication. ... Merge replication. ... Key-based incremental replication. ... Transactional replication. ... Log-based incremental replication.