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

Posted in Blog | Tagged , , | 2 Comments

The Tech That is Gone

The world of technology has undergone an amazing revolution in my lifetime. Things that I thought were incredible in my youth have come and gone in the world. I’m sure that there were dramatic changes in technology across lots of other generations, but I wonder if they were as dramatic for others as they feel for me.

As I watch older movies, I’m amazed at the evolutions. I was watching an older sitcom recently and saw someone using a cordless phone. While we have these cordless mobile devices, there was a time when having a phone in my house that wasn’t tethered to a spot on the wall was incredible. And I haven’t seen one of these in years.

My Mother worked in real estate and getting an answering machine was critical technology for growing her business. These were essential in every home for a long time (along with call waiting). First tape-based, then SSD, but now these devices are really gone and exist in the cloud. Now you get voice mail and call waiting on a mobile device. Does anyone have an answering machine anymore? For that matter, are there still public phones? I’ve seen a few booths in my travels, but they seem to be mostly standing as tourist attractions for pictures or repurposed as small libraries or wi-fi hotspots.

One of my big career steps was working with an import company that lived off faxes. When I was there, we went from a single computer-based fax service to upgraded multi-line fax add-in boards with not only digital fax reception but the OCR of the actual recipient to email the images to the appropriate department. It was an amazing job where I learned a lot about imaging and large-scale storage of data. I know there are companies that still have fax machines, but emailing images around seems to have overtaken this in much of the world.

We still have mainframes and lots of older applications, but one piece of software I expected to see around was Lotus Notes. I know some people might still use it, but IBM doesn’t support it. They’ve outsourced. I guess a lot of software I used early in my career is gone: Ami Pro, WordPerfect, Lotus 1-2-3, and more.

Maybe one interesting device my wife loved was a Palm Pilot. There were lots of PDAs for a while, but the advances in mobile phones completely did away with that category of devices. I’m actually still amazed that Blackberry couldn’t survive the transition to screen-based devices. For a time it felt like everyone in business carried one around.

Hard disks and tape changers seem to be fading, though I’m sure someone still uses them. Anyone bought a tape drive for their personal or business use anytime in the last few years? Or for that matter, do you still use CDs or floppy disks anymore? VHS tapes? Dot-matrix printers?

What about a modem? The sound of a modem connecting was both amazing for me as a young man and an annoying sound early in my career. Same for pagers. I loved getting one but hated carrying it. While there might be these devices in use somewhere, for the most part this technology has been removed from our lives.

Perhaps one of my favorite devices, which came late and died quickly, was the iPod. I had a few digital music players, but they were hard to manage. The iPod was revolutionary, and I had quite a few over the years. I still have a waterproof Shuffle I use when I swim, but for the most part, these devices are just memories.

What tech do you miss, or remember fondly? Or perhaps, what old tech do you still work with that you enjoy?

Steve Jones

Listen to the podcast at Libsyn, Stitcher, Spotify, or iTunes.

Posted in Editorial | Tagged | Comments Off on The Tech That is Gone

Daily Coping 4 Jan 2023

Today’s coping tip is to share something helpful with a friend that you learned recently.

I share a lot with my wife and kids. They are a big part of my life, and it’s important to make them a part of mine. I’m not a big shar-er in general, and they might say I don’t share a lot, but they get more than anyone else.

One of the things I learned recently was during my volleyball coaching certification. One of the modules looked at a seasonal plan for coaching. I hadn’t thought of breaking the season this way, but the advice was:

  • First third – 50% single skills, 30% controlled drills, 20% play, bonding
  • Second third – team system, look at stats, strategies, hide weakness
  • Final third – 80% play, offense/defense concepts

I think that’s a good approach and my wife and I are thinking to implement this.

The other thing I learned and shared was serving percentages over time from different locations to different ones. We’re emphasizing players think about this:

2022-11-09 12_42_20-Volleyball_ Correlation between server location and serve success2022-11-09 12_41_53-Volleyball_ Correlation between server location and serve success2022-11-09 12_40_49-Volleyball_ Correlation between server location and serve success

I started to add a daily coping tip to the SQL Server Central newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 4 Jan 2023

Daily Coping 3 Jan 2023

Today’s coping tip is to use one of your strengths in a new or creative way.

I have a lot of strengths. They’ve helped me to be successful. This tip is a hard one for me, as I need to get out of my comfort zone and try something new.

One of the strengths that has helped me is explaining concepts, ideas, etc. to others. It’s a lot of what has helped grow SQL Server Central over the year.

I’m going to take some time to explain how I approached some problems in Power BI and then take feedback. I’m sure there will be lots of suggestions and advice that helps me improve, but my goal is to provide a model that even though I’m not a guru or an expert, I’m going to display what I know, and then improve based on what I learn from others.

Hopefully I get more of you to blog and showcase your knowledge in the same way.

I’m starting with two projects. A Flyway one (first post tomorrow) and a Power BI one next week.

I started to add a daily coping tip to the SQL Server Central newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 3 Jan 2023