Installing FlywayDB

I’ve been working on a demo for a customer. Part of the demo uses a new Redgate product, but Flyway is a part of that. In testing a couple things, I realized that I didn’t have FlywayDB installed on  this new machine, so I did a quick walkthrough.

Installation

This is actually simple, or fairly simple. First, download the .zip file from Flyway.

2020-08-06 10_41_58-Command-line - Command-line tool - Flyway by Redgate • Database Migrations Made

Next, put this somewhere. For me, I wanted to be organized, so I put this in C:\Program Files\Red Gate. This did require some UAC approval to unzip the download into this spot.

2020-08-07 16_38_20-Red Gate 

Once I did this, I saw the flyway.cmd file in the subfolder. The instructions note I need to add this to my path.

2020-08-07 16_38_48-flyway-6.5.3

There are different ways to add things to the path, but the quickest for me on Windows 10, is to get to the properties of “This PC”. There is an advanced system settings here.

2020-08-07 16_39_24-System

This let’s me see properties, including the “Environment Variables” at the bottom.

2020-08-07 16_39_30-System Properties

Clicking this shows me the various system variables, including the PATH.

2020-08-07 16_39_41-Environment Variables

If I edit this, I get a standard dialog where I can add the Flyway folder.

Once done, I can test this with “flyway info” at a command prompt.

 

One note, if I have a command prompt open, I need to restart it to get the new path.

Licensing Flyway

This is an interesting item. I didn’t directly find an answer in the quick start. Most people probably use the Community edition, so they don’t need a key. I, however, wanted to play with the Enterprise version. I got a key from Redgate, and then set the environment variable. As you can see below, this isn’t enough. I got an error that I didn’t have a license.

2020-08-06 10_37_08-cmd

I wasn’t sure if flyway.licenseKey is a file or a setting. I looked around a bit, and on the download and install page, I found an item doe the Configuration. This mentions that the first place Flyway looks is the install folder/conf/flyway.conf. Aha!

I looked in the conf folder under my Flyway install. Under here is the flyway.conf file, which is a key-value configuration file. It reminds me of the old  Windows 3.1 .ini files.

2020-08-06 10_34_25-conf

When I open this, I see a lot of values. These are mostly commented out with a #. If you need to enable a value, remove the comment at the start of the line.

2020-08-06 10_35_55-flyway.conf - Visual Studio Code

Scrolling to the bottom shows me that the last entry is for the license key. I removed the comment character (# ) and then pasted in my key.

2020-08-06 10_39_08-flyway.conf - Visual Studio Code

The next time I ran flyway info I see this:

2020-08-12 14_06_29-cmd

No license message, though obviously I haven’t set up the connections yet.

That gets me started, and I know things are installed. Now I need to start using it, which is something for another post.

About way0utwest

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

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 )

Google photo

You are commenting using your Google 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.