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.
Schema Compare supports:
Note
You cannot compare compressed backups.
You cannot compare encrypted backups.
You cannot compare backups of databases with Transparent Data Encryption (TDE) enabled.
Schema Compare does not support Azure SQL database backups.
Schema Compare does not support partial, filegroup, or transaction log backups.
Schema Compare does not 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.
With Schema Compare, you can:
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.