- Transactional
- Snapshot
- Merge
Snapshot replication distributes data exactly as it appears at a specific moment in time and does not monitor for updates to the data. Snapshot replication is best used as a method for replicating data that changes infrequently or where the most up-to-date values (low latency) are not a requirement. Whensynchronization occurs, the entire snapshot is generated and sent to Subscribers.
Transactional replication, an initial snapshot of data is applied at Subscribers, and then when data modifications are made at the Publisher, the individual transactions are captured and propagated to Subscribers.
Merge replication is the process of distributing data from Publisher to Subscribers, allowing the Publisher and Subscribers to make updates while connected or disconnected, and then merging the updates between sites when they are connected.
3 comments:
Got a clear picture about Replication Types. Thank you
Mua vé máy bay tại Aivivu, tham khảo
vé máy bay đi Mỹ khứ hồi
đặt vé máy bay giá rẻ từ mỹ về việt nam
nhật về việt nam
lich bay tu duc ve viet nam
vé máy bay từ canada về việt nam giá rẻ
ve may bay tu han quoc ve viet nam
bảng giá khách sạn cách ly tại hà nội
chuyen bay danh cho chuyen gia
I want to read more of your good articles. Well done. สล็อตเครดิตฟรี
Post a Comment