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

Program of addition of byte type variables – c# program, Program of additio...

Program of addition of byte type variables - C# Program Program of addition of byte type variables, i need program code for performing addition of byte type variables. Can any

Web server connections, Question 1 Discuss the following with respect to ....

Question 1 Discuss the following with respect to .NET Technologies Web Applications Web Server Connections Question 2 Write a sample program using ASP.NET explain

Program, finding greatest of n no''s in c#

finding greatest of n no''s in c#

What is the difference between view state and session state, What Is The Di...

What Is The Difference Between ViewState and SessionState? View State persist the values of controls of certain page in the client (browser) when post back operation done. When

Explain the postback process as use with web forms, Question: (a) Expla...

Question: (a) Explain the Postback process as use with Web Forms. (b) Write extract codes to demonstrate how to store and retrieve values in: (i) a Session Object (ii)

Benefits and limitations of using cookies, What are benefits and limitation...

What are benefits and limitations of using Cookies? The benefits of using cookies for state management are as follows:- 1)    There is no server resources required as they a

I want a c# windows app, I want a C# Windows App Project Description: ...

I want a C# Windows App Project Description: Windows App written in C# that can: Check for Internet connection Load dynamic web site If Internet connection drops rec

Develop outlook add-in for all versions, Develop Outlook Add-In for all ver...

Develop Outlook Add-In for all versions I need simple code for Outlook(express,2003,2007,2010,2013) Add-In with functionality to repeatedly send CC to the specified email(s), th

C# coding to include user specified screen recording to app, C# coding to i...

C# coding to include user specified screen recording to app Project Description: Reposting as selected coder didn't read brief and accepted job to do then tell me would be in

Windows 8.1 project - asset management slate app, I need Windows 8.1 Projec...

I need Windows 8.1 Project, Asset management slate App Project Description: We are seeking a Windows 8 app developer with PROVABLE experience to prepare a project and asset m

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