There was an update to Flyway Desktop which lets you see the type of database your project is associated with, and this post shows how to get this in your list of projects.
As an example, you can see below my first project is a “SQL Server” project.
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.
Two Simple Steps
The first step to seeing the type of database project is to upgrade Flyway Desktop. The team is releasing basically every week. My version, upgraded before this post, is 6.9.3, so anything after this should have this capability.
The second step is you need to open your project. If I open the “DBCode” project above, it starts the comparison.
I don’t have to wait for the comparison, I can just close the project. Once I do, the type of project appears on the right side.
If you’ve been working with Flyway Desktop for awhile, you might have noticed an “Upgrade project” in the upper right. This is to upgrade the project from a JSON format to a TOML format, which doesn’t matter for you, but it does make the management of the internals of Flyway and Flyway Desktop easier for the developers.
In any case, you don’t need to upgrade the project. If I open and close a PostgreSQL project, I see this:
If I reopen the FWPoC_PostgreSQL project (named before this feature appeared), I see the upgrade is still there.
Try it 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: