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