Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Different types of replication in SQL Server
10-07-2014, 04:23 PM,
#1
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.
reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Windows RDP Server For Sale ringocom2018 0 127 22-10-2022, 05:40 AM
Last Post: ringocom2018
  VOS3000 2.1.6.0 One Time Installation Provide on your linux server ringocom2018 0 49 06-11-2021, 06:28 AM
Last Post: ringocom2018
  MediaCore offer - Sign up this month and get a free server! maryna.po.speedflow 0 55 20-07-2021, 09:13 AM
Last Post: maryna.po.speedflow
  24 Core 16 GB 2TB Dedicated Server with 1000 mbps Internet Port $64/month akhi 0 116 11-08-2019, 09:23 AM
Last Post: akhi
  VOS3000 Server Provider in India - Cheap Price ringocom2018 0 145 12-07-2019, 02:46 PM
Last Post: ringocom2018
  Support & Reinstalaltion of VOS3000 Free For Next 6 Month On Same Server eshs 0 111 26-03-2019, 09:54 AM
Last Post: eshs
  Economy Cloud Server offers [email protected] 0 149 03-01-2019, 10:54 AM
Last Post: [email protected]
  Economy Cloud Server offerings radhika 0 124 02-01-2019, 02:12 PM
Last Post: radhika
  Economy Cloud Server offerings [email protected] 0 126 31-12-2018, 04:47 PM
Last Post: [email protected]
  Economy Cloud Server offerings [email protected] 0 96 30-12-2018, 11:14 AM
Last Post: [email protected]

Forum Jump:


Contact UsVoIP Call Provider ForumReturn to TopLite (Archive) ModeRSS Syndication