Redgate Summit – The Database DevOps Transformation Register now

Flyway Commercial Licensing FAQ

Commercial Licensing FAQ

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, support older databases, and provide additional support options for customers.

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

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.

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

The different editions of Flyway come with different support timeline guarantees for database releases. For Flyway Community a database release is guaranteed to be supported for 5 years from its GA (General Availability) release date.

Flyway Teams Edition gives you stronger guarantees by extending it to a full 10 years. 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.

If you require support for a database release that’s older than 10 years, please contact us.

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 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.​

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

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.

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

You are above the 100 schema limit, and must purchase Flyway Enterprise

Only the schemas managed by Flyway in the production environment count. Needless to say if a schema is not managed by Flyway, there is no need to include it in your calculation. The same applies to dev, test and staging environments.

Note that both schemas managed by Flyway directly using a database connection as well as schemas managed by Flyway-generated dry run scripts must be counted.

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.