Published 21 August 2019
To use SQL Compare you need:
Windows Server 2008 R2 or later, or Windows 7 or later
- Microsoft .NET Framework 4.7.2 or later
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
How long are database releases supported?
The database versions supported in each licensed product depends on its Database Compatibility Tier.
At the Community Compatibility Tier a database release is guaranteed to be supported for 5 years from its GA (General Availability) release date. At the Teams compatibility level this is extended it to a full 10 years, and at the Enterprise compatibility level, additional selected database versions are supported. Each edition gives you the strong predictability you need to be able to manage your database upgrade cycles at the pace you require.
Example: Oracle 12.2 went GA in March 2017. It is guaranteed to be compatible with Flyway Community until at least March 2022. After that date support will be retired from Community Edition, but it is guaranteed to still remain available until at least March 2027 with Flyway Teams Edition.
Note that products in the Teams Compatibility Tier include support for database versions in Community tier, and products in the Enterprise Compatibility Tier include support for all database versions in Teams tier.
|Product||Assigned Database Compatibility Tier|
|SQL Source Control (standalone)||Teams (SQL Server databases only, excluding Azure SQL Database, Azure SQL Database Managed Instance and Amazon RDS)|
|Source Control for Oracle (standalone)||Teams (Oracle databases only)|
|SQL Change Automation||Enterprise (SQL Server databases only with the exception of Azure SQL Database Managed Instance)|
|SQL Compare, SQL Data Compare Professional Edition||Enterprise (SQL Server databases only)|
|SQL Compare, SQL Data Compare Standard Edition||Enterprise (SQL Server databases only)|
|Schema Compare for Oracle, Data Compare for Oracle||Enterprise (Oracle databases only)|
*Capabilities of Redgate Deploy that are powered by a comparison engine, such as auto-script generation, are limited to SQL Server and Oracle, with PostgreSQL and MySQL support to be supported next.
Note: This database version compatibility table is accurate as of January 2022. Database versions will change compatibility tiers database versions reach their 5 and 10 year milestones. The release dates of each database version provided below can be used to anticipate when support in a given tier will lapse. Please contact firstname.lastname@example.org for more information.