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
We need vb.net windows application programmer with min six years exp to work on our email marketing project Project Description: We need a windows application vb.net programm

What is code access security (CAS)? Code access security (CAS) is part of the .NET security model that stops unauthorized access of resources and operations, and restricts the

Project Description: We require a Part time or long contract, Programmer/Developer working in Sydney. Task - Write PHP software into asp.net. Develop new software to enhan

List the new features added in .NET Framework 4.0. The following are the latest features of .NET Framework 4.0:     Improved Application Compatibility and Deployment Support

I am seeking to get a logo design for a business. Skills required: .NET, HTML, Graphic Design, PHP, Website Design

Explain keywords with example. Keywords are those words that are reserved to be used for an exact task. These words cannot be used as identifiers. You cannot use a keyword to

Avoid deadlock in threading The best  and careful planning may avoid deadlocks.There are so many ways Microsoft has provided by which you can decrease deadlocks for example Int

What is the difference amonga system workflow and a human workflow? A system workflow is a workflow that is developed to automate interactions between applications. Such workfl

What is Windows DNA architecture? The Windows Distributed internet Applications Architecture (DNA) is a Microsoft blueprint for scalable, robust, & distributed business softwar

Project Description: I need to get lync server 2013 fixed the issues it has hit: 1) Can't connect to it outside network, I think small firewall problem with a little issue in