Voice of the DBA

Tag: Redgate

  • Come to a Redgate Summit in 2024

    This week is the first Redgate Summit of 2024. It’s Wednesday, in Atlanta and you can register and join me if you’re in the area.

    These are full day conferences, with multiple tracks, similar to the SQL in the City conferences we used to run. With our move to supporting database professionals on any platform, anywhere, we’ve rebranded these as Redgate Summits. Come join me at one of the following dates, if you are anywhere in the area:

    I’m not sure if we’ll be doing Redgate Summits in AUS this year, but I’ll be in Brisbane, Sydney, and Melbourne in May.

    The Atlanta schedule is packed, with especially for Grant and me, but we’ve got engineers, Friends of Redgate, and other experts coming. We’ve got some AI experts as well, and with three tracks, there will be plenty for you to learn. Ask us questions, get inspired, find out how you can better build and manage database software.

    Hopefully I’ll see you are one of these events this year.

    Now, back to holiday today for me, as I’m coaching the final day of Colorado Crossroads for my 13s team, as well as helping with an 18s team.

  • Friday Flyway Tips–Undoing Development Changes

    I had a customer ask about undoing changes made by developers, similar to what SQL Source Control does. I had to do a little research to show how to do this, which is the tip this week.

    I’ve been working with Flyway Desktop for work more and more as we transition from older SSMS plugins to the standalone tool. This series looks at some tips I’ve gotten along the way.

    Making Changes in Development

    I’ve got a few changes I want to make. You can see these in the image below, where I’ve added a column and then a couple of tables.

    2024-02-29 11_30_19-Custom Selection

    I test this (hopefully) and I come to Flyway Desktop, where I can see all my changes listed in the Schema Model tab.

    2024-02-29 11_30_35-Custom Selection

    At this point, I realize that I’ve done something I don’t want. I don’t want the column to be named something. Maybe I misspelled it, or maybe I modeled it wrong. I can easily fix this in Flyway Desktop.

    At the top, you see there is a Save to Project and Apply to Database set of radio buttons.

    2024-02-29 14_17_05-

    This is a two way comparison, with the options reversing each other. The Save item will write database changes to the file system in the repo. The Apply will read the repo and make the changes in the database.

    In this case, you can see below that when I select the Apply radio button, I get the notification that my column will be deleted.

    2024-02-29 11_30_56-Highlight

    Once I click “Apply to Database” (the big blue button), these changes are made.

    If I check the database, I can see my column is removed, but my tables still exist, since I didn’t check their boxes on the left.

    I’ve undone a change. Now I can commit these two tables, if that’s what I need, or I can also add back a better named column and refresh this if needed.

    Try Flyway Enterprise out today. If you haven’t worked with Flyway Desktop, download it today. There is a free version that organizes migrations and paid versions with many more features.

    Video Walkthrough

    I made a quick video showing this as well. You can watch it below, or check out all the Flyway videos I’ve added:

  • The Redgate Summit in Atlanta

    ca693884-4339-4efe-960d-e8c7c1d3706f

    Navigating the Database Landscape is the headline of our Redgate Summit in Atlanta on Mar 13. I’m doing the Keynote with Grant Fritchey and Kathi Kellenberger with this title, and we’re also presenting a few other sessions.

    We’ve partnered with Octopus Deploy and a number of community experts to bring you thought leaderships, panels, product demos, and more. It’s a packed schedule with three tracks, great good, and some inspiring conversations.

    I hope you can join me if you’re in the area that week. Register today for Atlanta.

    We also have Summits coming to these cities:

  • Friday Flyway Tips–Quick Command Line Access

    One of the things I had to do recently in a demo was access the Git command line. The way I did it impressed a customer, so I put together a quick tip.

    I’ve been working with Flyway Desktop for work more and more as we transition from older SSMS plugins to the standalone tool. This series looks at some tips I’ve gotten along the way.

    Working with Git and Flyway Desktop

    When working with a Flyway Desktop project, you see a screen like this. Most of the time, this works great, and as I showed in another tip, the VCS Git client is on the right side in a blade.

    2024-02-28 14_51_37-Flyway Desktop

    If you need to get to the Git repo from a shell, you need to open a shell and then navigate with CMDs to the right location. Or open the location in Explorer and type CMD. However, in the upper right corner, there is a shell icon, which is highlighted below.

    2024-02-28 14_51_49-Zoomit Zoom Window

    If you click this, the default shell opens in the correct location. In this case, it’s not the repo root, but rather the project root.

    2024-02-28 14_51_56-cmd

    I can then run my git commands, like “git status”, and I get relevant results for this project. As you can see below, I have 6 changes, which matches the 6 uncommitted changes in FWD.

    2024-02-28 14_52_20-Zoomit Zoom Window

    That’s it. Quick access to the repo from the CMD shell.

    Try Flyway Enterprise out today. If you haven’t worked with Flyway Desktop, download it today. There is a free version that organizes migrations and paid versions with many more features.

    Video Walkthrough

    I made a quick video showing this as well. You can watch it below, or check out all the Flyway videos I’ve added: