What is database replication and What are the different types of replication
| Replication is a process from which we copying/moving data between databases on the same or different servers.There are three types of replication which i have define bellow.
(1)Snapshot replication:This replication means data doennot get changed or updateIt can be used when data changes are infrequent its mainly used when we have to view data or some information. (2)Transactional replication :-This would happen when change is done to the data |
|
| .
(3)Merge replication - It is the process of distributing the data between publisher and subscriber,it allows the publisher and subscriber to update the data while connected or disconnected, and then merging the updates between the sites when they are connected | |