7.6.6 - 24 October 2024

Improvements

• Added additional logging to trace Flyway invocation details

Library Versions

• Flyway: 10.20.1-rc343095
• RG Compare: 1.24.2.24235
• Electron: 33.0.2

7.6.5 - 23 October 2024

Fixes

• Fixed an issue where comparisons with PostgreSQL could include changes in schemas not included in the project

Library Versions

• Flyway: 10.20.1-rc340203
• RG Compare: 1.24.2.24216
• Electron: 33.0.2

7.6.4 - 16 October 2024

(Note: this release has been pulled)

New Features

• Added menu button to easily access Flyway Service from within Flyway Desktop

Fixes

• Fixed an issue where the Migrations page would not refresh upon closing and opening different projects
• Fixed an issue where modifications would not save to schema model for Oracle projects

Library Versions

• Flyway: 10.20.0-rc331622
• RG Compare: 1.23.1.24149
• Electron: 33.0.0

7.6.3 - 03 October 2024

(Note: this release has been pulled)

Library Versions

• Flyway: 10.19.0-rc312564
• RG Compare: 1.23.0.23969
• Electron: 32.1.2

7.6.2 - 26 September 2024

Breaking Changes

• Previously ‘flyway-dev diff’ required passing an environment over stdin as a JSON object if either ‘–from’ or ‘–to’ was ‘target’. Now you must specify the target environment’s id to ‘–targetId’ when comparing with a target.

Fixes

• Fixed truncation of long branch names in git branch dropdown
• Fixed truncation of long file paths in git file lists

Library Versions

• Flyway: 10.18.2-rc303576
• RG Compare: 1.23.0.23871
• Electron: 32.1.2

7.6.1 - 24 September 2024

Changes

• Results from running the Flyway CLI now only appear in logs when the logging level is verbose and not by default

Library Versions

• Flyway: 10.19.0-rc290664
• RG Compare: 1.22.2.23810
• Electron: 32.1.2

7.6.0 - 30 August 2024

Fixes

• Fixed a bug which sometimes blocked saving to schema model for PostgreSql projects

Library Versions

• Flyway: 10.17.3-rc279037
• RG Compare: 1.22.1.23470
• Electron: 32.0.1

7.5.0 - 27 August 2024

Fixes

• Fixed an issue where difference text for changes in Postgres projects would error on retrieval

Library Versions

• Flyway: 10.17.3-rc276519
• RG Compare: 1.22.0.23388
• Electron: 32.0.1

7.4.0 - 22 August 2024

Improvements

• Object definitions can now be retrieved even if there are many thousands of difference objects - there was previously a cut-off after which definitions were no longer retrieved
• Page load of the Schema Model, Generate Migrations, and Deployment pages is now slightly faster as object definitions are no longer retrieved as part of the comparison

Changes

• Object definitions are no longer retrieved as part of the comparison used to load the Schema Model, Generate Migrations, or Deployment pages. Instead they are retrieved after the page has loaded. As such, you may now get a one-time progress indicator when loading definitions. For smaller result sets, all definitions will be loaded at once as before.
• Comparison artifacts generated from this version of Flyway Desktop will have their IDs calculated differently. This means the same comparison with an older version of Flyway Desktop will have a different ID

Library Versions

• Flyway: 10.17.2-rc273950
• RG Compare: 1.21.5.23328
• Electron: 32.0.1

7.3.13 - 13 August 2024

Library Versions

• Flyway: 10.17.1-rc265010
• RG Compare: 1.21.3.23109
• Electron: 31.3.1

7.3.12 - 12 August 2024

Library Versions

• Flyway: 10.17.1-rc263751
• RG Compare: 1.21.3.23109
• Electron: 31.3.1

7.3.11 - 06 August 2024

Fixes

• Fixed an issue where generated Baseline script configuration files were not syncing their name with the Baseline script

Library Versions

• Flyway: 10.17.1-rc262255
• RG Compare: 1.21.3.23074
• Electron: 31.3.1

7.3.10 - 29 July 2024

Library Versions

• Flyway: 10.17.0-rc254377
• RG Compare: 1.21.2.23000
• Electron: 31.3.0

7.3.9 - 25 July 2024

Fixes

• Fixed an issue where a failed migration would not automatically refresh migration information
• Fixed an issue where multiple ‘Future’ migrations could show the same version on the Migrations page

Library Versions

• Flyway: 10.17.0-rc251707
• RG Compare: 1.21.2.22957
• Electron: 31.3.0

7.3.8 - 22 July 2024

Library Versions

• Flyway: 10.17.0-rc249214
• RG Compare: 1.21.2.22892
• Electron: 31.2.1

7.3.7 - 19 July 2024

Improvements

• Migrations page now shows execution progress when running ‘migrate’

Library Versions

• Flyway: 10.16.1-rc248371
• RG Compare: 1.21.2.22877
• Electron: 31.2.1

7.3.6 - 16 July 2024

Library Versions

• Flyway: 10.16.0-rc244514
• RG Compare: 1.20.2.22785
• Electron: 31.2.1

7.3.5 - 15 July 2024

Library Versions

• Flyway: 10.16.0-rc243458
• RG Compare: 1.20.2.22735
• Electron: 31.2.0

7.3.4 - 05 July 2024

Improvements

• Migrations are generated using the encoding specified in the toml

Changes

• Removed grouping from the changes table on the Deploy page
• Moved actions for the table on the Deploy page to the panel header
• Diffs for database objects use ‘Ignore whitespace’ comparison options when deciding to show whitespace changes

Fixes

• Fixed an issue where lots of deployment warnings could prevent the deployment script from being visible
• Fixed an issue where the about page was unable to determine the Flyway CLI version

Library Versions

• Flyway: 10.16.0-rc230277
• RG Compare: 1.20.2.22646
• Electron: 31.1.0

7.3.3 - 02 July 2024

Library Versions

• Flyway: 10.16.0-rc230277
• RG Compare: 1.20.2.22631
• Electron: 31.1.0

7.3.2 - 24 June 2024

Improvements

• Flyway desktop will now fall back to online/offline licenses if permit defined in REDGATE_LICENSING_PERMIT_PATHS is invalid
• Diff operations will show progress in the taskbar/dock where OS supports

Library Versions

• Flyway: 10.15.1-rc224140
• RG Compare: 1.20.1.22565
• Electron: 31.0.2

7.3.1 - 18 June 2024

New Features

• Added a settings pane to diff windows, where users can toggle highlighting whitespace differences, as well as whether their diff is split or unified

Changes

• Differences on the Deployment page are now grouped by schema and object type

Library Versions

• Flyway: 10.15.1-rc219838
• RG Compare: 1.20.1.22519
• Electron: 31.0.1

7.3.0 - 17 June 2024

New Features

• VCS integration is now available in Community Edition

Fixes

• Fixed an issue where Views would appear as tables to track Static Data for

Library Versions

• Flyway: 10.15.1-rc219342
• RG Compare: 1.20.1.22493
• Electron: 31.0.1

7.2.9 - 05 June 2024

New Features

• Added Deploy rules UI that allows graphical editing of the shouldExecute expression. Deploy rules are set for each migration to control when each one runs. This includes selecting environments you want the migration to run against and allowing you to query specific placeholders and their values to further control execution.

Improvements

• It is now possible to read non-UTF-8 migrations in the UI, honouring the flyway.encoding setting
• It is now possible to save new manually added migrations in the encoding specified by flyway.encoding

Changes

• The flyway-dev import verb has been removed in favour of flyway init

Fixes

• Fixed issue handling extended characters in database passwords

Library Versions

• Flyway: 10.14.1-rc209364
• RG Compare: 1.20.0.22330
• Electron: 30.0.9

7.2.8 - 29 May 2024

Library Versions

• Flyway: 10.13.1-rc188874
• RG Compare: 1.20.0.22234
• Electron: 30.0.8

7.2.7 - 23 May 2024

New Features

• Added support for Databricks

Library Versions

• Flyway: 10.13.1-rc188874
• RG Compare: 1.20.0.22163
• Electron: 30.0.7

7.2.6 - 22 May 2024

Improvements

• Redesigned target database selection on the Deploy page

Library Versions

• Flyway: 10.13.1-rc188874
• RG Compare: 1.20.0.22117
• Electron: 30.0.6

7.2.5 - 21 May 2024

Improvements

• On Windows, the Minimize, Maximize and Close buttons are now part of the application header.
• The VCS commit tab’s list of files now uses more descriptive icons and titles

Changes

• The application menus have been reorganized to place the help menu as the last menu.

Fixes

• Git conflicts resolved outside of Flyway Desktop will now be recognised as being resolved by Flyway Desktop

Library Versions

• Flyway: 10.13.1-rc188874
• RG Compare: 1.20.0.22117
• Electron: 30.0.6

7.2.4 - 15 May 2024

Improvements

• Cloning a new project will now no longer prompt for toml project file if there is one (and only one) in the repository
• On pull/commit/push, the corresponding button now displays a loading spinner
• When importing from SQL Source Control the project Guid is now preserved

Fixes

• Fixed issue where SQL Source Control default options would not be applied on import if no custom options were set, resulting in collations being ignored after import
• Fixed issue where docker provisioner connections would not fail to connect following browsing for the compose file

Library Versions

• Flyway: 10.13.1-rc188874
• RG Compare: 1.20.0.22091
• Electron: 30.0.4

7.2.3 - 13 May 2024

Improvements

• Place target DB tooltips on the left to prevent hiding items in the dropdown

Changes

• We have made a change to authentication which may require you to sign in again. If you use an offline license, this won’t affect you

Fixes

• Fixed issue where deployment source might not appear for pre-populated database type

Library Versions

• Flyway: 10.12.1-rc184910
• RG Compare: 1.19.9.22056
• Electron: 30.0.3

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