SQL Compare - 10.0

SQL Compare

Working with snapshots - SQL Compare

SQL Compare enables you to create a snapshot of a database and compare it with another data source. A SQL Compare snapshot is a binary file containing information about the structure of a database; it does not contain any table data.

You can use snapshots:

Creating snapshots

To create a new SQL Compare snapshot, on the File menu, select Create Snapshot. Alternatively, on the Project Configuration dialog box, select a snapshot as one of the data sources, and click Create Snapshot.

The Create New Snapshot dialog box is displayed:

Under Data source details, specify the details of the source for the snapshot. You can create a snapshot from a database, backup, scripts folder, or another snapshot.

Under Snapshot creation properties, specify a name and location for the snapshot.

SQL Compare automatically detects the case sensitivity of the data source. If you want to override this, clear the Auto detect case sensitivity check box, and select the Treat items as case sensitive check box if required.

By default, SQL Compare decrypts text objects in SQL Server 2008 and SQL Server 2005 databases that were created using the WITH ENCRYPTION option. When comparing large databases, selecting this option can result in slower performance.

Note that:

  • when the source is a snapshot, the case sensitivity and decryption options are not available
  • when the source is a scripts folder, the decryption option is not available
  • you can also create a snapshot using SQL Snapper

    SQL Snapper is a free tool that creates SQL Compare snapshots from SQL Server databases. You can download SQL Snapper from the Red Gate Labs website.

Comparing and deploying snapshots

You can:

  • compare a snapshot with another data source

    See: Setting data sources.

  • create a deployment script from a snapshot

When a SQL Compare snapshot is the target, deployment creates a script to update the database from which the snapshot was created. Snapshots cannot be modified directly.

When a snapshot is the source, and a database is the target, the database can be updated to synchronize it with the snapshot.

This is useful, for example, if you want to roll back changes. If you have made changes to a database, and created a snapshot before deployment, you can then set the snapshot as the source, and the database as the target, to roll back the changes.

For more information, see: Using the Deployment wizard.

Compatibility with previous versions of SQL Compare

Snapshots created using SQL Compare versions 3, 4, 5, 6, or 7 can be used in this version of SQL Compare.

However, if the Add WITH ENCRYPTION option was selected when you created a snapshot using SQL Compare version 3, the comparison or deployment may fail when you use the snapshot in this version of SQL Compare.

See also

Working with scripts folders

Working with backups

Understanding the comparison results

Viewing the comparison results

Setting data sources

Setting project options

Was this article helpful?

Search support
Forums
Visit the SQL Compare forum.
Learning SQL Compare
Knowledge base

SQL Compare

all SQL products

all products

Notes & articles

SQL Compare

all SQL products

all products

Demos & walkthroughs

SQL Compare