Voice of the DBA

Category: Blog

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

  • Daily Coping 17 Aug 2020

    I started to add a daily coping tip to the SQLServerCentral 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.

    Today’s tip is to spend time wishing for other people to be free of suffering.

    em·pa·thy – the ability to understand and share the feelings of another.

    As I get older, I try more and more to empathize with others. Put myself in their shoes and understand how they feel.

    There is a lot of suffering in the world, all the time, but many people right now that have planned for the future, worked hard, put themselves in good situations, and with the changes of the pandemic, they are suffering.

    Particularly, I think about many of the people I’ve met over the years in airports. Lots of them work in coffee shops, restaurants, bus drivers, and more. These are are people I used to see every month, sometimes every week. I know a couple of them are out of work. Furloughed or laid off because of a lack of business from travel.

    For the few I personally know and have seen around town, I’m sure there are dozens or hundreds more in Denver. Likely thousands around the world that are suffering. Some might miss meals, some might have lost housing. Most, or all, are likely feeling a lot of stress from a situation that is out of their control.

    I took a few minutes to sit and think about all the people I used to see in my travels that are hurting now. I hope they find a path through this pandemic world.

  • Daily Coping 14 Aug 2020

    I started to add a daily coping tip to the SQLServerCentral 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.

    Today’s tip is to ask someone how they feel and really listen to their reply.

    I know far too many people that don’t listen in conversations. They may have an idea of what you said, but really they want to do one of two things:

    • get away and not talk
    • get back to talking about what they want to speak to

    I’ve been guilty of both of these, but I try to be better, and I try to listen to others more.

    As a result, I tried this recently. My wife and I had dinner with a friend, and rather than impose my thoughts, I listened more. I did ask them about how they feel about the pandemic, and their coping, since their situation is much different than mine.

    I didn’t give advice, or evaluate what they said, I listened and supported them, expressing sympathy for challenges, acknowledging things were hard, and enjoying the bright spots they pointed out.

  • Daily Coping 13 Aug 2020

    I started to add a daily coping tip to the SQLServerCentral 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.

    Today’s tip is to treat everyone you interact with as though they are a friend.

    This tip is a part of my world and life. I try hard to greet people warmly and treat them well. Whether it’s the cashier at the gas station, the produce person restocking the grocery, someone walking their dog in a park, and certainly people I meet at events.

    It’s easy to get annoyed by life, or to retreat. It’s easy to be wary of others. It’s easy to assume things about another person based on their appearance. We all do it. We all have internal voices that pre-judge people and situations.

    We sometimes have good reasons to do so. However, no matter what you worry, try to treat someone you interact with as a friend first. Greet them, talk with interest, listen, and enjoy their company.

    You can always walk away. That’s a skill worth developing as well.