Flyway Desktop 7 release notes
Published 21 December 2023
7.2.2 - 25 April 2024
Fixes
- Fixed bug where the Generate Migrations page would not let users refresh if they pressed cancel after generating a baseline
Library Versions
- Flyway: 10.11.1-rc167821
- RG Compare: 1.19.7.21913
- Electron: 30.0.1
7.2.1 - 23 April 2024
Fixes
- Fixed an issue where MySQL scripts with names containing
--
might cause incorrect syntax highlighting - Fixed an issue where the New branch modal wouldn’t auto focus
Library Versions
- Flyway: 10.11.1-rc167821
- RG Compare: 1.19.7.21881
- Electron: 30.0.1
7.2.0 - 17 April 2024
New Features
- It is now possible to deploy directly from the schema model to a target database using a new tab. This tab is not currently visible for projects using migrations. While migrations are the safest way to deploy changes to a database, schema model deployment can be useful for projects that do not require the full power of migrations. Schema model deployment can be enabled during project creation or through the project configuration modal, although it cannot be enabled if migrations are already in use.
Improvements
- Improved static data table performance when initially loading
- Improved contrast of command and settings accordions on Migrations page
Changes
- Updated icons to align with Material icons. The main noticeable change is the Schema icon
Fixes
- Fixed an issue where the Manage target databases modal would increase in width if there were no target databases
- Fixed the wording of some comparison option descriptions
Library Versions
- Flyway: 10.11.1-rc166113
- RG Compare: 1.19.7.21820
- Electron: 30.0.0
7.1.11 - 11 April 2024
New Features
- Added preview support for Apache Cassandra
Improvements
- Added warning modal to new project page when creating a project inside a folder that already contains a project
Changes
- No longer perform automatic Git fetch on window focus
Fixes
- Fixed issue where importing from SQL Source Control would not work
properly with a
\
at the end of the source path - Fixed issue where script config disabling transactions would be generated with wrong prefix against baseline migrations
Library Versions
- Flyway: 10.11.0-rc153804
- RG Compare: 1.19.7.21721
- Electron: 29.3.0
7.1.10 - 27 March 2024
Improvements
- Improved some error messages on SQL Source Control import failure
- Improved some error messages on Source Control for Oracle import failure
- It is now possible to import a SQL Source Control working base folder (enabling import for repositories which don’t use Git or working folder)
- It is now possible to import a Source Control for Oracle working base folder (enabling import for repositories which don’t use Git or working folder)
Fixes
- Fixed issue where importing from SQL Source Control would not work
properly with a
\
at the end of the source path
Library Versions
- Flyway: 10.11.0-rc147646
- RG Compare: 1.19.7.13456
- Electron: 29.1.5
7.1.9 - 19 March 2024
Library Versions
- Flyway: 10.10.0
- RG Compare: 1.19.7.13385
- Electron: 29.1.4
7.1.8 - 18 March 2024
Improvements
- Improved git conflict resolution experience by prompting message if user has no mergetool configured
Changes
- Minor UI tweaks to styling of buttons
Fixes
- Fixed issue where VCS side panel would sometimes execute git fetch twice at once leading to error banner appearing
- Fixed issue where errors cleaning the shadow database would not be reported correctly if flyway engine returned content on stderr
- Fixed issue where the version number would not increment correctly when adding new migrations and using non-SQL migration suffix, e.g. when in a MongoDB project
Library Versions
- Flyway: 10.10.0
- RG Compare: 1.19.7.13385
- Electron: 29.1.4
7.1.7 - 05 March 2024
Fixes
- Fixed an issue where database variants (e.g. CockroachDB as a PostgreSQL variant) would error trying to identify the correct driver in the connection dialog
Library Versions
- Flyway: 10.8.1
- RG Compare: 1.19.6.13291
- Electron: 29.1.0
7.1.6 - 28 February 2024
Fixes
- Fixed an issue where rows in the invalid objects table could become unresponsive
Library Versions
- Flyway: 10.8.1
- RG Compare: 1.19.6.13227
- Flyway Compare: 1.0.2
- Electron: 29.0.1
7.1.5 - 27 February 2024
Improvements
- An indicator with the branch name has been added to all pages, making the current branch always visible
Library Versions
- Flyway: 10.8.1
- RG Compare: 1.19.6.13227
- SQL Compare engine: 15.3.3.25269
- Compare for Oracle engine: 6.3.1.2110
- Electron: 29.0.1
7.1.4 - 19 February 2024
Changes
- Flyway Desktop now saves if the navigation sidebar is open or closed
Library Versions
- Flyway: 10.8.1
- RG Compare: 1.19.6.13134
- SQL Compare engine: 15.3.2.25249
- Compare for Oracle engine: 6.3.1.2094
- Electron: 28.2.3
7.1.3 - 12 February 2024
Fixes
- Fixed issue where temporary files might be left around in “%localappdata%/Temp/Red Gate” following SQL Server and Oracle database comparisons. Note that the contents of this folder can be safely deleted.
- Fixed an issue where Flyway Desktop could open a schema model for SQL Server that contained invalid syntax
- Fixed an issue where a warning would incorrectly appear during baselining an Oracle database stating that the database version is deprecated
- Fixed an issue where overriding
reportEnabled
would cause a parsing issue in Flyway CLI. - Fixed an issue where credential storage would not properly update to plain text if password field was empty
Library Versions
- Flyway: 10.7.2
- RG Compare: 1.19.6.13016
- SQL Compare engine: 15.3.2.25236
- Compare for Oracle engine: 6.3.1.2086
- Electron: 28.2.2
7.1.2 - 05 February 2024
Changes
- Change diffs no longer wrap text in order to keep diffs aligned
Fixes
- Fixed issue where flyway command line would not log output
Library Versions
- Flyway: 10.7.1
- RG Compare: 1.19.6.12910
- SQL Compare engine: 15.3.1.25174
- Compare for Oracle engine: 6.3.1.2061
- Electron: 28.2.1
7.1.1 - 01 February 2024
New Features
- Added dark theme to Flyway Desktop, available via a theme toggle in the application header menu
- ClickHouse support available, supplied by community contributors.
Fixes
- Fixed issue when using SQL Server LocalDB where tables could not be retrieved for configuring static data
- Fixed issue where recent projects on landing page could not be scrolled
- Resolving merge conflicts via the version control tab now opens the globally configured git resolution tool
Library Versions
- Flyway: 10.7.1
- RG Compare: 1.19.5.12868
- SQL Compare engine: 15.3.1.25159
- Compare for Oracle engine: 6.3.1.2061
- Electron: 28.2.1
7.1.0 - 30 January 2024
Improvements
- Added better UI handling for invalid SQL Server port numbers and server names.
- Added better error handling for errors coming from the flyway engine
Fixes
- Fixed an issue where Flyway Desktop may log database connection strings including target database authentication data to application debug logs stored on the local computer
Library Versions
- Flyway: 10.6.0
- RG Compare: 1.19.4.12805
- SQL Compare engine: 15.3.1.25150
- Compare for Oracle engine: 6.3.1.2057
- Electron: 28.2.0
7.0.11 - 23 January 2024
Library Versions
- Flyway: 10.6.0
- RG Compare: 1.19.4.12679
- SQL Compare engine: 15.3.1.25140
- Compare for Oracle engine: 6.3.1.2042
- Electron: 28.1.4
7.0.10 - 19 January 2024
Fixes
- Fixed an issue where Undo migration’s version wasn’t updating alongside the Versioned migration’s version
- Fixed issue fetching static data tables
Library Versions
- Flyway: 10.6.0
- RG Compare: 1.19.4.12622
- SQL Compare engine: 15.3.1.25130
- Compare for Oracle engine: 6.3.1.2042
- Electron: 28.1.4
7.0.9 - 18 January 2024
New Features
- Flyway now supports privileges and owner properties for PostgreSQL. If you don’t want to track privileges, they can be filtered out; see PostgreSQL and MySQL filtering for details.
Library Versions
- Flyway: 10.6.0
- RG Compare: 1.19.4.12622
- SQL Compare engine: 15.3.1.25110
- Compare for Oracle engine: 6.3.1.2042
- Electron: 28.1.4
7.0.8 - 17 January 2024
Library Versions
- Flyway: 10.6.0
- RG Compare: 1.19.3.12605
- SQL Compare engine: 15.3.1.25086
- Compare for Oracle engine: 6.3.0.2028
- Electron: 28.1.4
7.0.7 - 16 January 2024
Improvements
- Added problem type column to invalid objects modal prompt during baselining
Library Versions
- Flyway: 10.5.0
- RG Compare: 1.19.3.12600
- SQL Compare engine: 15.3.1.25086
- Compare for Oracle engine: 6.3.0.2028
- Electron: 28.1.3
7.0.6 - 15 January 2024
Improvements
- Added better UI handling for SQL Server Local DB
- The project settings configuration modal will now show an ‘Unsaved changes’ banner
Fixes
- Notification pop-ups from VCS errors will now show correctly.
Library Versions
- Flyway: 10.5.0
- RG Compare: 1.19.3.12532
- SQL Compare engine: 15.3.1.25070
- Compare for Oracle engine: 6.3.0.2026
- Electron: 28.1.3
7.0.5 - 11 January 2024
Changes
- Changes to project settings now keep target connection if it has not changed
Fixes
- Fixed VCS sidebar issue where user couldn’t push or pull when initialising a repository through the UI then connecting to a remote
- Fixed VCS sidebar issue where viewing diff of a file as part of a first commit on a branch would fail
Library Versions
- Flyway: 10.5.0
- RG Compare: 1.18.3.12465
- SQL Compare engine: 15.2.8.24977
- Compare for Oracle engine: 6.2.6.2017
- Electron: 28.1.3
7.0.4 - 09 January 2024
New Features
- There is now support for the JTDS driver (which supports local DB) in the connection dialog for SQL Server projects. Note that for Windows authentication the ntlmauth.dll file needs to be downloaded and added to the ./flyway/native folder within the Flyway Desktop installation.
Improvements
- Placeholder text will now be shown for fields derived from Redgate Clone in the list of target databases
Changes
- Replaced tabs with a navigation sidebar
Fixes
- Fixed an issue where a byte order mark might be generated mid-file when generating a SQL Server migration script with both schema and data changes. This was functionally harmless but showed up as a question mark artifact when viewing the script in the UI.
- Fixed an issue where undo migrations weren’t being saved with the correct file name if the corresponding versioned migration name was modified.
- Fixed an issue where errors might not be displayed correctly when failing to connect to a database from the connection dialog
Library Versions
- Flyway: 10.4.1
- RG Compare: 1.18.3.12465
- SQL Compare engine: 15.2.8.24943
- Compare for Oracle engine: 6.2.6.2007
- Electron: 28.1.2
7.0.3 - 03 January 2024
Improvements
- When hovering over a target database on the Migrations tab, a tooltip will show with the database’s URL
Fixes
- Fixed issue where static data information would be missing after importing from a SQL Source Control project
- Fixed issue where invalid objects in Oracle couldn’t be compiled
Library Versions
- Flyway: 10.4.1
- RG Compare: 1.18.3.12399
- SQL Compare engine: 15.2.8.24895
- Compare for Oracle engine: 6.2.6.1994
- Electron: 28.1.0
7.0.2 - 22 December 2023
Fixes
- Fixed error showing in UI when resizing window while VCS diff view visible
- Fixed issue resolving shadow database when generating migrations
Library Versions
- Flyway: 10.4.1
- RG Compare: 1.18.3.12371
- SQL Compare engine: 15.2.7.24867
- Compare for Oracle engine: 6.2.6.1994
- Electron: 28.1.0
7.0.1 - 21 December 2023
Breaking Changes
- The JSON project format used in flyway-dev.json and flyway-dev.user.json is now deprecated and support will be removed in the next major version release. It is possible to upgrade projects from the UI.
- The ‘flyway-dev’ command-line now requires a license to be set in order to use it. If you are licensed with a Flyway license key, you will need to set this in an environment variable called ‘FLYWAY_LICENSE_KEY’. If not, you can follow this documentation on how to set an offline license as an environment variable - https://documentation.red-gate.com/fd/licensing-164167730.html
New Features
- The Version Control page has been replaced with a side panel. All
features available on the old page are still available via the side
panel. The following new features have been added:
- It is now possible to view the differences for files to commit
- It is now possible to view commits to pull, and to view the files within those commits, and the differences within those files
- It is now possible to view commits to push, and to view the files within those commits, and the differences within those files
- It is now possible to trigger a manual fetch
- Added preview support for provisioning via Redgate Clone or Docker when connecting to databases. Provisioning via a clone can be used as an alternative to baselining and is recommended for very large databases.
- When connecting to databases, Flyway Desktop will now support retrieving credentials from Vault, Dapper, and Google Cloud Secrets Management (though this is not yet supported in the connection dialog UI)
Improvements
- It is now possible to expand the script editor form in the generated migrations tab.
Library Versions
- Flyway: 10.4.0
- RG Compare: 1.18.3.12356
- SQL Compare engine: 15.2.7.24867
- Compare for Oracle engine: 6.2.6.1984
- Electron: 28.0.0