Snapshot Replication

  • Article

Snapshot replication distributes data exactly as it appears at a specific moment in time and does not monitor for updates to the data. When synchronization occurs, the entire snapshot is generated and sent to Subscribers.

Note

Snapshot replication can be used by itself, but the snapshot process, which creates a copy of all the objects and data specified by a publication, is also commonly used to provide the initial set of data and database objects for transactional and merge publications. For more information, see Initializing a Subscription with a Snapshot in SQL Server 2005 Books Online.

Using snapshot replication by itself is most appropriate when one or more of the following is true:

  • Data changes infrequently.
  • It is acceptable to have copies of data that are out of date with respect to the Publisher for a period of time.
  • You are replicating small volumes of data.
  • Many changes occur over a short period of time.

Snapshot replication is most appropriate when data changes are substantial but infrequent. For example, if a sales organization maintains a product price list and the prices are all updated at the same time once or twice each year, replicating the entire snapshot of data after it has changed is recommended. Given certain types of data, more frequent snapshots might also be appropriate. For example, if a relatively small table is updated at the Publisher during the day, but some latency is acceptable, changes can be delivered nightly as a snapshot.

Snapshot replication has a lower continuous overhead on the Publisher than transactional replication because incremental changes are not tracked. However, if the dataset set being replicated is very large, it will require substantial resources to generate and apply the snapshot. Consider the size of the entire data set and the frequency of changes to the data when evaluating whether to use snapshot replication.

For information about implementing snapshot replication, see Implementing Replication in SQL Server 2005 Books Online.

See Also

Concepts

Transactional Replication
Merge Replication
Replication Components
Replication Considerations (SQL Server Express)

Help and Information

Getting SQL Server 2005 Assistance