Replication and What are Its Tools
Replication is a technology for copying and distributing data and database objects from one database to another. The databases are then uniformly synchronized to ensure consistency. There are several ways to distribute data to different locations and mobile or remote users - over wireless and dial-up connections, local and wide area networks, and the Internet. There are mainly three types of SQL server replication tools. Snapshot Replication – A “snapshot” of all data on one server is taken and the data is moved to another server or another database in the same server. After the first synchronization snapshot, replication refreshes the data in published tables over fixed pre-programmed periods. While this technology is the easiest to set up and maintain, all data has to be copied every time a table is refreshed. Transactional Replication- It copies data from the publisher to the subscriber/s once and then transports the transactions to the subscriber/s as and when they take place ...