Importance of SQL Server Replication
- January 06, 2010
Just like the SQL Server replication of SQL server is also important. SQL Server replications allows administrators to divide data to various servers all over an organization. Importance of replication can be understood by following below given reasons:
Offline Processing – there are many users round the world who wish to change data from your database on a machine even when their status is offline i.e. when they are not connected to the network.
Redundancy – with the help of replication you can build a fail-over database server, in case of any failure it can pick up the processing, even on a minute’s notice.
Load balancing – with the help of replication you can divide your data on large number of servers and thus you divide the query load between those servers. Replication therefore helps in enhancing the quality of a dedicated server.
Snapshot Replication – it works just like the name indicates. All what publishers have to do is take a snapshot of the entire replicated database and share that with subscribers. Snapshot replication is not used by most of the administrators because of the reason that snapshot replication is resources intensive process. Most commonly snapshot replication is used in those database which rarely undergoes any change. Other use of snapshot replication is to establish replication between systems at the same time as updates are broadcasted with the help of combined replication.
Merge Replication – this type of publisher allows subscribers to make changes independent to the database. Spatiality of these two applications is that they can work without network connection. When connected again the merger replication feature confirm changes made on both sides and make changes in each database. In the case of changes contradict with each other, there is a provision of conflict resolution algorithm which concludes the suitable data. Most common users or merge replication are laptop users, who didn’t get chance to connect to the publishers continuously.
Transactional Replication – best advantage of Transactional replication is it allows database to undergo any change on a regular basis. With transactional replication publishers can monitor changes occurring on the database an then transmitting those changes to the subscribers. This kind of replication can work immediately or on a periodic basis.