Snapshot Replication In SQL Server 2008
In this article I explain about snapshot replication.
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.