SQL Compare 14

To use SQL Compare you need:

Support for reading backups

The 'backup' data source type has further limitations:

Natively compressed / encrypted backups are not supported
Advanced table features, e.g. file tables, memory-optimized tables, temporal tables are not supported
Some SQL Server 2012+ only object types, e.g. sequences are not supported

Database and database version support for the products listed in the table below are aligned to support for Flyway Teams and Flyway Enterprise.

Database compatibility levels:

Flyway Community

Flyway Teams

Flyway Enterprise

Flyway Enterprise
SQL Change Automation (3)
SQL Source Control (as part of Flyway Enterprise, SQL Toolbelt Essentials or SQL Toolbelt) (1)
SQL Compare (4)
SQL Data Compare Professional Edition (4)
Schema Compare for Oracle (2)
Data Compare for Oracle (2)

(1) SQL Server databases only, excluding Azure SQL Database, Azure SQL Database Managed Instance and Amazon RDS

(2) Oracle databases only

(3) SQL Server databases only with the exception of Azure SQL Database Managed Instance

(4) SQL Server databases only