Different types of replication supported by sql server, DOT NET Programming

What are the different types of replication supported by SQL SERVER?

There are 3  types of replication supported by SQL SERVER which are shown below:-

1) Snapshot Replication:

The Snapshot Replication takes snapshot of one database and moves it to the another database. After the initial load the data can be refreshed periodically. The only demirt of this type of replication is that all data has to be copied every time the table is refreshed.

2) Transactional Replication:

In the transactional replication the data is copied first time as in snapshot replication, but later only the transactions are synchronized rather than replicating the entire database.You can either specify to run continuously or on the periodic basis.

3) Merge Replication:

The Merge replication combines data from the multiple sources into a single central database.As usual the initial load is like snapshot but later it allows the change of data both on subscriber and the publisher, after that when they come on-line it detects and combines them and updates accordingly.

Posted Date: 9/24/2012 3:28:36 AM | Location : United States







Related Discussions:- Different types of replication supported by sql server, Assignment Help, Ask Question on Different types of replication supported by sql server, Get Answer, Expert's Help, Different types of replication supported by sql server Discussions

Write discussion on Different types of replication supported by sql server
Your posts are moderated
Related Questions
Explain the difference between an ADO.NET Dataset and an ADO Recordset. The two main basic differences between recordset and dataset are as shown below :- 1) With the datase

Training and placement cell Project Description: It is about placement and training cell of any college. I have made this for one college. If needed, i can modify it. Student

What are benefits and limitations of using Hidden frames 1)    The benefits of using hidden frames are as follows: 2)    More than one data field can cache. 3)    The abi

MVC -C# Single Page Application Project Description: Construct a site similar to prototype: To explain briefly: 1) Single Page Application 2) Loginig funcionality


What is object-oriented programming (OOP)? OOP is a technique to develop logical modules, like classes that contain properties, methods, fields, and events. An object is formed

Converting $ into Rs.  - C# Program I am a learner of C# language and i am struggling with how to convert $ into Rs. in C#. Can you have any code examples for this?

Sorting 2 Arrays & Merging into 1 - C# Program Hello, i didn't find the correct way to implement Array in my project. I am beginner for this language.  Please suggest me some

We previously use Site content filtering inside Netkiosk But at present this blocks sites. or keywords We now also require a Whitelist that allows. 1) An entire domain www

I want to develop SMS application with auto reply based on the content of the message using gsm modem. eg.Student results checking using cell phone via sms. How do i do this?