Difference between Transactional,Snapshot and Merge Replication Transactional replication – Transactional replication replicates each transaction from publisher to subscriber for the article/table which is being published. Initially transactional replication takes a snapshot of the publisher database and applies to the subscriber to synchronize the data. As we know that replication is helpful...
Monday, December 29, 2014
Sunday, December 28, 2014
Snapshot Replication (Setting up Subscriber) in SQL Server 2008: Part 3 This article is a continuation of the following articles: SNAPSHOT REPLICATION IN SQL SERVER 2008: PART1 SNAPSHOT REPLICATION (SETTING UP PUBLISHER) IN SQL SERVER 2008: PART2 I thought to keep the pictorial concept so that anyone can easily setup and map at their end....
Tuesday, December 16, 2014
Snapshot Replication (Setting up Publisher) in SQL Server 2008: Part2 This is a continuation of the Snapshot Replication in SQL Server 2008: Part 1.In these articles I’ll shed light on Setting up Publisher in Snapshot Replication and recommend you to read an article as shown as link. I thought to keep the pictorial representation...
Monday, December 15, 2014
Snapshot Replication in SQL Server 2008: Part1 Replication is one of the headstone features of SQL Server to keep data synchronize among various server. There are basically three types of replication present in SQL server Transactional,Snapshot and Merge Replication .In this article I’ll cover Snapshot Replication. As name implies “Snapshot” means...
Subscribe to:
Posts
(
Atom
)
