PASS Data Community Summit logo

PASS Data Community Summit 2023

Get all the latest announcements direct to your inbox

Roadmap

Find out what the teams are developing, and check out what’s new in Flyway

The mission

To make it as easy to deliver database changes as it is for application code changes.

Our Database Deployment development teams aim to enable companies to achieve effortless continuous delivery of database changes, mirror the application DevOps processes to speed up the software development lifecycle and avoid data being a bottleneck for innovation.

Subscribe for new version alerts

We'll send you occasional emails about new Flyway features.

What's new

Flyway Engine 9.5.0 (2022-10-19) (full release notes)

Changes

  • Ensure correct version of SQLFluff is installed
  • Update version of 'commons-text' to fix vulnerability CVE-2022-42889
  • Add edition to the version model
  • When urls are unsupported by check, ascertain which ones are unsupported, and include them as part of the exception.

Database compatibility

New features

  • Add custom code analysis rule that requires tables to have a primary key
  • Add syntax highlighting to dry run reports
  • Issue 3519 - Replace SQLPlus placeholders that begin with a double '&'
Flyway Desktop (full release notes)

Changes

  • Generate undo migration scripts
  • Only pending migrations shown on migrations tab
  • Verify database migration scripts
  • Initialize local Git repositories
  • Ability to delete branches
  • Configure multiple targets for each project to check migration status, see script execution time, and run flyway commands
  • Edit development databases within the UI and save to project or user settings
  • New check command added to Migrations tab for running change reports and drift detection against targets
  • Manually add migration scripts
  • Flyway Desktop now available on macOS
  • Limited functionality of Flyway Desktop available in Flyway Teams and Flyway Community (Preview)

What's next

In development

Flyway Engine

  • Advanced code analysis rules

Flyway Desktop

  • Cloning a Git repo when opening a project – Improved onboarding experience for new team members
  • Version control static data and include in migration scripts generation
  • Improved version control integration throughout Flyway Desktop
  • Full comparison support for PostgreSQL (currently in Early Access Preview)
  • Extending check command for code analysis
  • Integrating Redgate Clone for dedicated development databases and dedicated databases for Git branches

Cross Database Provisioning

  • Database provisioning capabilities for SQL Server, Postgres, Oracle, and MySQL databases to use in dev/test processes
Researching

Flyway Desktop

  • Import SQL Source Control and Source Control for Oracle projects
  • An improved experience for pulling and applying change to development databases
  • More location options when adding migrations
  • UI for comparison options and filters
  • Full comparison support for MySQL
  • Full comparison support for Snowflake
  • Easier re-baseline experience

We're here to help 0800 028 0309

Contact us to find out how Flyway can help your team deliver value quicker while keeping your data safe.

The industry standard tools for 20 years

Redgate has specialized in database software for 20 years. Our products are used by 804,000 IT professionals, in more than 100,000 companies.

World-class support

Redgate offers comprehensive documentation and a friendly, helpful support team. An average 87% of customers rate our support 'Excellent'.