Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wkm1925
Posting Yak Master
207 Posts |
 Posted - 2010-10-27 : 00:59:24
|
| Hi,My understanding of SQL Server Replication are1. Snapshot Replication2. Transactional Replication3. Merge ReplicationMy problem is i dont know the different between them. I hope someone can share with the easy understanding of these |
|
|
vna_mhars
Starting Member
37 Posts |
Posted - 2010-10-27 : 03:07:24
|
| # Snapshot replication acts in the manner its name implies. The publisher simply takes a snapshot of the entire replicated database and shares it with the subscribers. Of course, this is a very time and resource-intensive process. For this reason, most administrators don’t use snapshot replication on a recurring basis for databases that change frequently. There are two scenarios where snapshot replication is commonly used. First, it is used for databases that rarely change. Second, it is used to set a baseline to establish replication between systems while future updates are propagated using transactional or merge replication.# Transactional replication offers a more flexible solution for databases that change on a regular basis. With transactional replication, the replication agent monitors the publisher for changes to the database and transmits those changes to the subscribers. This transmission can take place immediately or on a periodic basis.# Merge replication allows the publisher and subscriber to independently make changes to the database. Both entities can work without an active network connection. When they are reconnected, the merge replication agent checks for changes on both sets of data and modifies each database accordingly. If changes conflict with each other, it uses a predefined conflict resolution algorithm to determine the appropriate data. Merge replication is commonly used by laptop users and others who can not be constantly connected to the publisher.vamodente |
 |
|
|
wkm1925
Posting Yak Master
207 Posts |
Posted - 2010-10-27 : 22:49:37
|
| tq sir |
|
|
|
|
|
|
SQL Server Replication