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
What is DMAIC and DMADV? The Six Sigma has two key methodologies viz. DMAIC and DMADV. The DMAIC is used to improve an existing business process. While DMADV is used to create

What is .NET Remoting? The .NET remoting is replacement of DCOM. Using .NET remoting you can make remote object calls that lie on different Application Domains. since the remot

What is the use of data adapter? The Data adapter are the objects that connect one or more Command objects to a Dataset object. They give logic that would get data from the dat

Bug Prediction and Correction Project Description: The project is about the prediction of bugs and fixes the bug in the sample program using costriage algorithm. All the requ

I need Remote chat Application for desktop Project Description: I want a team of .net experts who will design me a website and a remote desktop chat application as like  live

Project Description: Simple task on analysis svn and github .NET, PHP, Engineering, Software Architecture

What is Absolute and Sliding expiration? The Absolute Expiration allows you to specify the duration of the cache, beginning from the time the cache is activated. The given exam

The Events are always public as they are meant to serve each one registering to it. But you can access modifiers in the events.You may have events with protected keyword which will

What are the different implementations of LINQ? The different implementations of LINQ are: LINQ to SQL - Refers to a component of.NET Framework version 3.5 that provides a

Explain Forms authentication in detail. In the old ASP if you were said to create a login page and do authentication you have to do lot of custom coding. But now in ASP.NET tha