Flyway

Here are the answers to the most frequently asked questions regarding commercial licensing:

If you can’t find the answer to your question here, please contact us at sales@flywaydb.org and we’ll be happy to help you.

What are the Flyway ‘Teams’ and ‘Enterprise’ editions?

Flyway ‘Teams’ and ‘Enterprise’ editions are a superset of Flyway Community edition which add more functionality and provide additional support options for customers.

As of September 2022. these licenses for these editions are sold on a “per user” basis. Learn more.

What happened to Flyway’s old editions?

Prior to 2019, Flyway had a paid edition called ‘Pro’. This edition was licensed “per schema”. As of Flyway’s version 7.0 release, this edition was combined into a new edition called Flyway Teams. Existing ‘Pro’ customers were upgraded to this edition for free.

Prior to 2019, Flyway had a paid edition called ‘Enterprise’. This edition was licensed “per schema”. As of Flyway’s version 7.0 release, this edition was combined into a new edition called Flyway Teams. Existing ‘Enterprise’ customers were transferred to become ‘Teams’ customers with all the same functionality.

As of September 2022, Flyway Teams is no longer available on a “per schema” to new customers. Existing customers should contact sales@flywaydb.org to discuss their per schema license renewal options.

If you are using a "per schema" license, then you will not have access to Flyway Desktop. Flyway Desktop is only available in the new "per user" licensing. Please contact sales@flywaydb.org to discuss any questions.

How long are database releases supported in each edition of Flyway?

The different editions of Flyway come with different support and compatibility timelines for database releases. For Flyway Community a database release is generally certified for 5 years from its GA (General Availability) release date.

The paid editions give you further guarantees with certified support extending to a full 10 years in Flyway Teams and extended beyond this with Flyway Enterprise. Each edition gives you the strong predictability you need to be able to manage your database upgrade cycles at the pace you require.

See the supported database and versions page for more detail.

Is there a trial version?

Yes there is. All you need to do is request a trial license key. This license key is valid for 28 days and can be used with Flyway Teams. After 28 days you must either upgrade to a full Flyway Teams or Flyway Enterprise edition license or downgrade to Flyway Community edition.

Do I have to set up a license server or open ports in my firewall?

No. Flyway does not need a license server and Flyway does not call home.

What is the license?

Here is the Commercial License.

How does licensing work?

New customers, from September 2022:

Every organization running Flyway Teams or Flyway Enterprise edition to manage databases on its own servers or cloud accounts must have a license.

The price is based on the number of people who need to install the tools, and/or are contributing, or inputting database changes, to a Pipeline.

“Pipeline” means any and all of the database environments that form part of an automated database change delivery process using our software.

Some example of a licensable user:

A user who chooses to install the Flyway tools for their own use, for example to interact with a Flyway project
A user who directly makes changes to a database that is part of a Flyway Pipeline
A user who indirectly makes changes to a database that is part of a Flyway Pipeline (eg the user authors the migration script or SQL script to make the change

Examples of those who aren't required to purchase a Flyway license (provided they don't fall in the categories listed above):

Those who review or approve a Flyway deployment
Those who read reports or other artifacts created by Flyway
Those who set up, configure and maintain the Flyway Pipeline (eg on a CI/CD tool)
A Service Account used to generate a PAT token (eg, for a CI/CD process)

Existing customers, prior to September 2022:

Every organization running Flyway Teams Edition to manage databases on its own servers or cloud accounts must have a license.

The price is based on the numbers of schemas in production managed by Flyway. You can use Flyway Teams with any number of schemas as long as the number of schemas in production is smaller or equal to the licensed amount. Development, test and staging environments are free and unlimited.

Existing customers who wish to expand your Flyway Teams Edition schema count beyond their current license should contact us at sales@flywaydb.org so we can discuss your options.

What exactly is a Pipeline?

“Pipeline” means any and all of the database environments that form part of an automated database change delivery process using our software.

What exactly is a Schema?

With schema we mean the container for database objects commonly referred to as “schema” and usually created using the CREATE SCHEMA DDL statement. This is the exact meaning for schema for each of the supported databases:

Oracle: USER (which is essentially a schema + a user)
SQL Server: SCHEMA
DB2: SCHEMA
MySQL: DATABASE or SCHEMA (both are synonyms)
MariaDB: DATABASE or SCHEMA (both are synonyms)
PostgreSQL: SCHEMA
Redshift: SCHEMA
CockroachDB: DATABASE (no schema support)
SAP HANA: SCHEMA
Sybase ASE: DATABASE (no schema support)
Informix: DATABASE (no schema support)
H2: SCHEMA
HSQLDB: SCHEMA
Derby: SCHEMA
Snowflake: SCHEMA
SQLite: DATABASE (no schema support)
Firebird: DATABASE (no schema support)
BigQuery: DATASET
Cloud Spanner: SCHEMA
MongoDB: DATABASE (no schema support)
Cassandra: DATABASE (no schema support)
Azure Synapse: SCHEMA
Clickhouse: SCHEMA
Databricks: DATABASE or SCHEMA
CloudSpanner: SCHEMA
Ignite: SCHEMA
TiDB: DATABASE or SCHEMA
TimescaleDB: SCHEMA
YugaByte: SCHEMA

How are schemas counted?

From September 2022

Flyway Teams and Enterprise editions are billed on a “per user” basis. However, the Teams edition license is limited to use in no more than 100 schema.

Determining if you have fewer or more than 100 schema:

Say you have 1 SQL Server instance running 5 databases, with each database containing 10 schemas. This amounts to 5 x 10 schemas = 50 schemas. How the schemas are spread among databases and database instances doesn’t matter.

In this case you are below the 100 schema limit, and can purchase Flyway Teams.

Now let’s say a schema is replicated across multiple database instances, each replica must be accounted for. This means that if you have your 50 schemas replicated across 5 SQL Server instances, it counts: 1 SQL Server instance x 5 server replications x 5 databases x 10 schemas each = 250

In this case you are above the 100 schema limit, and must purchase Flyway Enterprise

Which schema should I count?

You only need to count the number of schema in Production where Flyway has been used manage a change, which includes scenarios where:

You deploy with Flyway Migrate using a database connection to Production, or
You deploy manually to Production with a Flyway-generated dry-run script, or
You use Flyway to manage changes in non-Production environments, but manually script out and deploy the result to Production

Needless to say, if a schema is not or has never been managed by Flyway in any environment, there is no need to include it in your calculation.

Prior to September 2022 (“per schema” licensing):

Use the same calculation above to determine how many schema you require for your license.

Why does it show a higher price when I try to purchase?

Our prices do not include VAT or sales tax. In some countries, like the EU or Norway for example, VAT gets added to the price at the time of purchase. You can remove the VAT by clicking the “Enter VAT ID” link in the store and entering your company’s VAT ID. After the VAT is removed the price will once again match the advertised one.

What license term options are available?

Flyway subscriptions can be purchased for one, two or three year terms giving you the flexibility to choose the best term length for your needs. By opting for the two or three year terms you are able to lock in the current annual rate for the duration of the subscription keeping you on the best possible rate moving forwards.

How can I pay and see my licenses?

We can arrange an invoice for your Flyway license for Teams tier. You can register for a Redgate Account on our website www.red-gate.com to give you full visibility and management of your licenses.

I already own a license, how do I use it?

See upgrading to Teams for step-by-step instructions on how to upgrade your Flyway community installation to Flyway Teams.