Compare and synchronize backup files

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


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.

Compare and synchronize 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.


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.