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

Assignment Help:

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.


Related Discussions:- Different types of replication supported by sql server

Write a program of changing string order – c# program, Write a Program of C...

Write a Program of Changing String Order - C# Language  using System;   class Prog3_2  {       public static void Main(String [] args)    {     Console.Write(ar

Use a checkbox in a datagrid, How to use a checkbox in a datagrid? The ...

How to use a checkbox in a datagrid? The steps to be done are as follows:- 1)    In the ASPX page you have to add Itemtemplate tag in datagrid. 2) I

Differences between the detailsview and formview controls, Question: (a...

Question: (a) Give three key differences between the DetailsView and FormView controls. (b) The ASP.NET 2.0 Framework introduces the idea of validation groups. How Valida

Raise custom errors from stored procedure, How can you raise custom errors ...

How can you raise custom errors from stored procedure? The RAISERROR statements are  used to produce an ad hoc error message or to retrieve acustom message which is stored in t

B.Tech Project:Converting A Hand Drawn Diagram To A neat Dia, The project a...

The project aims at converting a rough hand drawn diagram to a neat diagram. Is it a good project for B.Tech level?Please tell how to go about it??

Can we run dot.net in unix platform, Can we run DOT.NET in UNIX platform? ...

Can we run DOT.NET in UNIX platform? One of the drawbacks of using Visual Studio.NET and the .NET framework to develop applications has been the lack of cross-platform support.

Explain the concept of web services in brief, Explain the concept of Web se...

Explain the concept of Web services in brief. A Web service may be explained as an independent and self-sustained unit of a software application that is hosted on the Web and i

Counting number of words in a string - c# program, Counting Number of Words...

Counting Number of Words in a String - C# Program Anyone can suggest me the output of the following program. using System;   class CountWords { public static void

Ado.net architecture, Can you give an overview of ADO.NET architecture? ...

Can you give an overview of ADO.NET architecture? The most important part  in the ADO.NET architecture is the "Data Provider". The  Data Provider provides access to the datasou

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd