|
Different types of replication in SQL Server
|
|
10-07-2014, 04:23 PM,
|
|||
|
|||
|
Different types of replication in SQL Server
Three types of replication in SQL SERVER 1. Snapshot Replication. In Snapshot Replication snapshot of one database is transferred to another database. In this replication data can be refreshed periodically and all data will be copied to another database every time the table is refreshed. 2. Transactional Replication In transactional replication data will be same as in snapshot replication, but later only the transactions are synchronized instead of replicating the whole database. We can specify the refresh of database either continuously or on periodic basis. 3. Merge Replication Merge replication replicate data from multiple sources into a single central database. The initial load will be same as in snapshot replication but later it allows change of data both on subscriber and publisher, later when they come on-line it detects and combines them and updates accordingly.
anil123, proud to be a member of VoIP Call Provider - Discussion Forums for the VoIP Call Provider since Jan 2014.
|
|||
|
« Next Oldest | Next Newest »
|
Search
Member List
Calendar
Help
