Installing Flyway Community on Windows

One of the things I’ve been trying to do is dig in more deeply to the Flyway command line (CLI) as part of my work with Redgate. While Flyway Desktop is amazing, it’s a wrapper, and my inclination is to ensure I understand the underlying technology.

When I first downloaded Flyway, it wasn’t obvious what needed to be done to connect in different ways, so I decided on a short tutorial that would help me remember how and teach others a few things. This post goes over downloading Flyway and getting started.

Setup

The setup for Flyway is easy. The Community version is free, though there are also Teams and Enterprise editions.

2022-12-27 10_42_52-Download   pricing - Flyway — Mozilla Firefox

Flyway Community works on many platforms. I’ll choose Windows below.

2022-12-27 10_44_47-Community edition - Flyway — Mozilla Firefox

The Windows version is a zip file. Click this, and it will download.

2022-12-27 10_45_35-Command-line - Command-line tool - Flyway by Redgate • Database Migrations Made

Then unzip this. I have a c:\Utilities folder where I keep stuff and I’ve added a flyway folder there. I unzip the latest into this folder.

2022-12-27 10_46_47-flyway

If you care about versioning, you might drop Flyway into a version named folder, but I typically don’t on this machine. For production deployments, I would be more careful.

You then need to add this to your PATH. If you are on Windows 10 or 11, then in the Control Panel (Windows+I), search for environment. Edit the variables for your account.

2022-12-27 10_47_57-Settings

Once the new dialog appears, find the PATH variable and click Edit.

2022-12-27 10_48_04-Environment Variables

Now add an entry for the folder where you extracted the Flyway files. For me, this is c:\utilities\flyway.

2022-12-27 10_48_12-Edit environment variable

That’s it, Flyway is installed.

We can check at the command line with “flyway version”.

2022-12-27 10_51_19-cmd

If you have entered a license key, then you’ll see that message.

2022-12-27 10_50_47-cmd

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , . Bookmark the permalink.

2 Responses to Installing Flyway Community on Windows

  1. Pingback: Getting Started Connecting to a Database with Flyway | Voice of the DBA

  2. Pingback: Getting Started Connecting to a Database with Flyway – SQLServerCentral

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.