Snapshot Replication In SQL Server 2008

In this article I explain about snapshot replication.
  • 1580

Snapshot replication

Snapshot replication creates a complete copy of the replicated objects and their data each time it runs. It does not monitor for updates of the data. The snapshot replication provides initial set of data  and database objects for transactional and merge publications.

Snapshot replication is used is mostly used in conditions when data changes are substantial but infrequent i.e. data hardly changes or a large number of changes takes place rapidly. Snapshot replication is appropriate when one or more of following condition is satisfied.

  • Infrequently changes in data.
  • Replicating small amount of data.
  • Large number of changes takes place over a short period of time.

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.