Replication

Replication is the process of copying,moving data between databases on the same or different servers. SQL Server supports the following types of replications

1.Snapshot replication
2.Transactional replication (with immediate updating subscribers, with queued updating subscribers)
3.Merge replication