Working with backups

With dbForge Schema Compare, you can compare backups with other data sources. This is useful, for example, if you need to retrieve a schema from a backup and compare or synchronize it with your database without running a time-consuming recovery operation or copying the backup from a remote network.

Compatibility issues

Schema Compare supports:

  • native SQL Server backups

Note:

You can’t compare compressed backups.

You can’t compare encrypted backups.

You can’t compare backups of databases with Transparent Data Encryption (TDE) enabled.

Schema Compare doesn’t support Azure SQL database backups.

Schema Compare doesn’t support partial, filegroup, or transaction log backups.

Schema Compare doesn’t read the log records of backup files, so in case the database schema was modified while the backup was being created, it may not be shown as modified in the comparison results.

Comparing and synchronizing backups

With Schema Compare you can:

  • compare a backup with another data source
  • create a synchronization script from a backup

When you select a backup as a target, the Schema Synchronization wizard creates a script to update the database from which the backup was created. Backups can’t be overwritten or modified directly.

Note:

When you run a comparison using a backup either as a source or a target, Schema Compare locks the backup files when it reads them, and you can’t overwrite, move, or delete them until you close the project.