Flyway

Detect out-of-process changes with Drift Alerts

Flyway Desktop 6 release notes

Page last updated 18 December 2023

6.11.9 - 18 December 2023

Improvements

  • flyway.check.majorTolerance is now set to 0 for new projects, so pipelines will fail on major inspection failures.

Library Versions

  • Flyway: 10.3.0
  • RG Compare: 1.18.2.12309
  • SQL Compare engine: 15.2.7.24832
  • Compare for Oracle engine: 6.2.5.1949
  • Electron: 28.0.0

6.11.8 - 11 December 2023

Changes

  • Removed the ‘Manage offlince license’ button when on the offline licensing page

Fixes

  • Fixed an issue where migrations on the Migrations tab would render multiple times in the table

Library Versions

  • Flyway: 10.2.0
  • RG Compare: 1.18.2.12220
  • SQL Compare engine: 15.2.6.24764
  • Compare for Oracle engine: 6.2.5.1949
  • Electron: 28.0.0

6.11.7 - 06 December 2023

Improvements

  • For the diff in the flyway-dev command line, when comparing a target database against the schema model, it is no longer necessary to define a development or shadow database in order to set the schemas used

Library Versions

  • Flyway: 10.1.0
  • RG Compare: 1.18.2.12141
  • SQL Compare engine: 15.2.6.24687
  • Compare for Oracle engine: 6.2.5.1937
  • Electron: 28.0.0

6.11.6 - 29 November 2023

New Features

  • MongoDB 7.0 support available. Currently shipped as preview.

Fixes

  • Trailing and leading whitespace is no longer permitted in new project names.

Library Versions

  • Flyway: 10.1.0
  • RG Compare: 1.18.1.12070
  • SQL Compare engine: 15.2.5.24552
  • Compare for Oracle engine: 6.2.5.1937
  • Electron: 27.1.2

6.11.5 - 28 November 2023

Library Versions

  • Flyway: 10.0.1
  • RG Compare: 1.18.1.12035
  • SQL Compare engine: 15.2.4.24551
  • Compare for Oracle engine: 6.2.5.1935
  • Electron: 27.1.2

6.11.4 - 27 November 2023

New Features

  • Added support for all check configuration parameters

Improvements

  • The RedGateDatabaseInfo.xml file in the schema model in SQL Server projects will now only be populated with major server version information, preventing unnecessary updates of this file when different users use development databases on different minor versions

Fixes

  • Fixed an issue where the static data page would reset to the first page after selecting a table to track
  • Default connection will no longer be cleared from the RedGateDatabaseInfo.xml file in the schema model for SQL Server projects

Library Versions

  • Flyway: 10.0.1
  • RG Compare: 1.18.1.12028
  • SQL Compare engine: 15.2.4.24549
  • Compare for Oracle engine: 6.2.5.1932
  • Electron: 27.1.2

6.11.3 - 21 November 2023

Breaking Changes

  • Updated to use dotnet 8 which drops support for RHEL 7

Fixes

  • Fixed an issue where the dropdown showing tables to configure for static data wouldn’t close when clicking away
  • Fixed an issue deserializing comparison artifacts for very large Oracle databases

Library Versions

  • Flyway: 10.0.1
  • RG Compare: 1.18.1.11911
  • SQL Compare engine: 15.2.3.24503
  • Compare for Oracle engine: 6.2.4.1929
  • Electron: 27.1.0

6.11.2 - 15 November 2023

Library Versions

  • Flyway: 10.0.1
  • RG Compare: 1.18.0.11761
  • SQL Compare engine: 15.2.3.24362
  • Compare for Oracle engine: 6.2.4.1901
  • Electron: 27.0.4

6.11.1 - 14 November 2023

Library Versions

  • Flyway: 10.0.0
  • RG Compare: 1.18.0.11761
  • SQL Compare engine: 15.2.3.24362
  • Compare for Oracle engine: 6.2.4.1901
  • Electron: 27.0.4

6.11.0 - 14 November 2023

Changes

  • Changed look and feel of table in migrations tab

Library Versions

  • Flyway: 10.0.0
  • RG Compare: 1.18.0.11761
  • SQL Compare engine: 15.2.3.24362
  • Compare for Oracle engine: 6.2.4.1901
  • Electron: 27.0.4

6.10.0 - 08 November 2023

Fixes

  • Fixed issue where connection dialog would reuse local secret key. If hitting this issue, please delete the password entry in the flyway.user.toml (or flyway-dev.user.json) file and resave the connection via the UI.

Library Versions

  • Flyway: 9.22.2
  • RG Compare: 1.18.0.11708
  • SQL Compare engine: 15.2.3.24277
  • Compare for Oracle engine: 6.2.4.1864
  • Electron: 27.0.3

6.9.3 - 07 November 2023

Improvements

  • The recent projects list will now show the database type for that project once it has been reopened.

Library Versions

  • Flyway: 9.22.2
  • RG Compare: 1.18.0.11708
  • SQL Compare engine: 15.2.2.24260
  • Compare for Oracle engine: 6.2.4.1858
  • Electron: 27.0.3

6.9.2 - 03 November 2023

Improvements

  • We no longer calculate object definitions when there are more than 50,000 differences to display. This should improve memory consumption when baselining large databases.

Library Versions

  • Flyway: 9.22.2
  • RG Compare: 1.18.0.11696
  • SQL Compare engine: 15.2.2.24244
  • Compare for Oracle engine: 6.2.4.1858
  • Electron: 27.0.3

6.9.1 - 02 November 2023

Fixes

  • Fix issue where a MySQL connection in a single-schema that doesn’t define the default database would cause an error when applying changes to the local development database
  • Fix issue where pasting a JDBC URL containing a username and password during Azure MFA auth connection would erroneously save these unnecessary details to flyway.user.toml.
  • Fixed issue where password was not being removed from config file when switching away from SQL Server password auth types

Library Versions

  • Flyway: 9.22.2
  • RG Compare: 1.18.0.11644
  • SQL Compare engine: 15.2.2.24241
  • Compare for Oracle engine: 6.2.4.1858
  • Electron: 27.0.3

6.9.0 - 31 October 2023

Changes

  • token is now handled via jdbcProperties.accessToken for environments defined in toml. This affects SQL Server Azure Active Directory interactive authentication only.
  • token is now handled via jdbcProperties.accessToken for target environment input of flyway-dev diff verb and output of flyway-dev resolve verb. This affects SQL Server Azure Active Directory interactive authentication only.

Fixes

  • Fix issue where similarly named Oracle permission differences would cause tables in UI to behave unusually

Library Versions

  • Flyway: 9.22.2
  • RG Compare: 1.17.0.11618
  • SQL Compare engine: 15.2.1.24235
  • Compare for Oracle engine: 6.2.4.1858
  • Electron: 27.0.2

6.8.9 - 30 October 2023

Fixes

  • Fixed scrolling on Schema model and Generate migrations tabs

Library Versions

  • Flyway: 9.22.2
  • RG Compare: 1.17.0.11563
  • SQL Compare engine: 15.2.1.24215
  • Compare for Oracle engine: 6.2.4.1852
  • Electron: 27.0.2

6.8.8 - 26 October 2023

New Features

  • Added filtering to invalid objects table

Fixes

  • Fixed an issue where some experimental features were enabled by default.

Library Versions

  • Flyway: 9.22.2
  • RG Compare: 1.17.0.11532
  • SQL Compare engine: 15.2.1.24199
  • Compare for Oracle engine: 6.2.4.1850
  • Electron: 27.0.2

6.8.7 - 25 October 2023

Improvements

  • When adding a new migration, the script editor now automatically has focus
  • Improved diff view resizing experience
  • There is now a prompt to fill in missing settings when opening a toml file without a project name or database type specified
  • The flyway.conf file is now renamed instead of deleted when used for import

Fixes

  • Default development database name set on flyway.conf import

Library Versions

  • Flyway: 9.22.2
  • RG Compare: 1.17.0.11459
  • SQL Compare engine: 15.2.1.24153
  • Compare for Oracle engine: 6.2.4.1850
  • Electron: 27.0.2

6.8.6 - 18 October 2023

Improvements

  • The baseline process will no longer fail on invalid object detection issues
  • When adding a new migration, the script editor now automatically has focus

Fixes

  • Fixed an issue where the Schema Model Apply summary wouldn’t scroll

Library Versions

  • Flyway: 9.22.2
  • RG Compare: 1.16.2.11419
  • SQL Compare engine: 15.2.1.24069
  • Compare for Oracle engine: 6.2.3.1835
  • Electron: 27.0.0

6.8.5 - 17 October 2023

Improvements

  • A new option redgateCompare.mysql.options.ignores.ignoreNewlinesInTextObjects is now available in PostgreSQL and MySQL TOML projects.
  • For the diff in the flyway-dev command line, when comparing against empty, it is no longer necessary to define a development or shadow database in order to set the schemas used
  • The baseline process will no longer fail on invalid object detection issues

Fixes

  • Fixed copy and expand actions being rendered off the edge of connection error banner
  • Fixed an issue where serialzing comparison artifacts could lead to out of memory exceptions

Library Versions

  • Flyway: 9.22.2
  • RG Compare: 1.16.2.11412
  • SQL Compare engine: 15.2.1.24069
  • Compare for Oracle engine: 6.2.3.1834
  • Electron: 27.0.0

6.8.4 - 11 October 2023

Changes

  • Set data compare option forceBinaryCollation to false by default

Fixes

  • Fixed an issue where a sign in check timing out could cause Flyway Desktop to sign out when it didn’t need to.

Library Versions

  • Flyway: 9.22.2
  • RG Compare: 1.16.1.11361
  • SQL Compare engine: 15.2.1.24069
  • Compare for Oracle engine: 6.2.3.1823
  • Electron: 27.0.0

6.8.3 - 05 October 2023

Changes

  • The MySQL “Edit Connection” dialog can now recognise jdbc:mariadb:.. urls, including the usePipelineAuth and useBatchMultiSend properties required for connecting to Aurora MySQL

Fixes

  • Increase timeout on sign in option

Library Versions

  • Flyway: 9.22.2
  • RG Compare: 1.16.1.11266
  • SQL Compare engine: 15.2.0.24040
  • Compare for Oracle engine: 6.2.3.1823
  • Electron: 26.2.4

6.8.2 - 03 October 2023

Library Versions

  • Flyway: 9.22.2
  • RG Compare: 1.16.1.11200
  • SQL Compare engine: 15.2.0.24040
  • Compare for Oracle engine: 6.2.3.1823
  • Electron: 26.2.4

6.8.1 - 28 September 2023

Library Versions

  • Flyway: 9.22.2
  • RG Compare: 1.16.1.11117
  • SQL Compare engine: 15.1.2.24012
  • Compare for Oracle engine: 6.2.3.1812
  • Electron: 26.2.3

6.8.0 - 26 September 2023

Fixes

  • Fixed issue where credentials could not be resolved when fetching the list of migrations

Library Versions

  • Flyway: 9.22.2
  • RG Compare: 1.16.1.11029
  • SQL Compare engine: 15.1.2.24001
  • Compare for Oracle engine: 6.2.2.1806
  • Electron: 26.2.2

6.7.1 - 26 September 2023

Improvements

  • Added additional debug logging for comparison artifact serialization and deserialization

Library Versions

  • Flyway: 9.22.2
  • RG Compare: 1.16.1.11029
  • SQL Compare engine: 15.1.2.24000
  • Compare for Oracle engine: 6.2.2.1806
  • Electron: 26.2.2

6.7.0 - 21 September 2023

Breaking Changes

  • Permit based licensing is now enabled for Windows. Windows users will be prompted to accept the Redgate EULA again on application start, and will then need to log in to Flyway Desktop again. Windows users who are using an offline version of Flyway Desktop will need to follow the offline activation workflow from the menu bar > License > Manage offline license, or alternatively configure the REDGATE_LICENSING_PERMIT_PATH environment variable.

Improvements

  • Flyway Desktop will now remember previously used locations for creating projects, matching the clone from version control form behaviour
  • New Offline Licensing workflow is now enabled on Windows
  • It is now possible to trial Teams and Enterprise editions of Flyway Desktop as two separate trials

Fixes

  • Fixed a vulnerability where when ‘flyway check’ is executed from Flyway Desktop and logging is enabled, an unredacted build database password is logged to Flyway Desktop’s local application log files (CVE-2023-43564)
  • Updated Flyway Engine to fix configuration disclosure in extended debug output (CVE-2023-43564)

Library Versions

  • Flyway: 9.22.1
  • RG Compare: 1.16.1.10936
  • SQL Compare engine: 15.1.2.23976
  • Compare for Oracle engine: 6.2.2.1782
  • Electron: 26.2.2

6.6.2 - 19 September 2023

Improvements

  • Environment ids are now visible but editing disabled on the development database and shadow database connection dialogs
  • Environment ids are now visible when configuring the list of target databases
  • Unnecessary connection parameters have now been removed from the flyway command line preview window, now that we set the environment parameter

Library Versions

  • Flyway: 9.22.1
  • RG Compare: 1.16.0.10912
  • SQL Compare engine: 15.1.1.23939
  • Compare for Oracle engine: 6.2.1.1770
  • Electron: 26.2.1

6.6.1 - 18 September 2023

Improvements

  • Closing the filter objects dialogue during baselining will now return you to the baseline dialogue.
  • Importing SQL Source Control and Source Control for Oracle projects will now store the lined database in the project settings for shared database projects

Library Versions

  • Flyway: 9.22.1
  • RG Compare: 1.16.0.10895
  • SQL Compare engine: 15.1.1.23931
  • Compare for Oracle engine: 6.2.1.1770
  • Electron: 26.2.1

6.6.0 - 14 September 2023

New Features

  • It is now possible to directly import SQL Source Control projects. Note that it isn’t possible to retrieve the full connection information for the development database and there will be a prompt to complete this on import.
  • It is now possible to directly import Source Control for Oracle projects. Note that it isn’t possible to retrieve the credentials for the development database and there will be a prompt to complete this on import.

Library Versions

  • Flyway: 9.22.1
  • RG Compare: 1.16.0.10855
  • SQL Compare engine: 15.1.1.23889
  • Compare for Oracle engine: 6.2.1.1761
  • Electron: 26.2.1

6.5.17 - 12 September 2023

Fixes

  • Fixed an issue with MySQL where comparisons could fail due to difference Ids being mismatched.
  • Fixed an issue where not having a development connection set could cause migration generation to fail.

Library Versions

  • Flyway: 9.22.0
  • RG Compare: 1.16.0.10836
  • SQL Compare engine: 15.1.1.23861
  • Compare for Oracle engine: 6.2.1.1756
  • Electron: 26.2.0

6.5.16 - 07 September 2023

Improvements

  • Open project dialog now displays helpful message on macOS

Changes

  • Flyway reports are no longer generated by default, and are added to the ‘.gitignore’

Library Versions

  • Flyway: 9.22.0
  • RG Compare: 1.16.0.10798
  • SQL Compare engine: 15.1.1.23842
  • Compare for Oracle engine: 6.2.0.1735
  • Electron: 26.2.0

6.5.15 - 06 September 2023

Improvements

  • Editing fields in the connection modal while a connection is being tested now aborts the test in progress and re-enables the save button.
  • Flyway Desktop will now prompt users to filter out objects during baselining if they’re detected as invalid.

Fixes

  • Fixed an issue in single shadow schema mode where baseline scripts were being generated with schema names, causing the scripts to fail on the shadow database.
  • Fixed an issue where the pending migrations window would disappear upon invalid parameters being entered, making the page unusable.

Library Versions

  • Flyway: 9.22.0
  • RG Compare: 1.16.0.10785
  • SQL Compare engine: 15.1.0.23826
  • Compare for Oracle engine: 6.2.0.1735
  • Electron: 26.1.0

6.5.14 - 30 August 2023

Improvements

  • Added a copy to clipboard button for the JDBC URL field.

Fixes

  • Fixed an issue preventing ‘flyway.conf’ projects from being imported

Library Versions

  • Flyway: 9.21.2
  • RG Compare: 1.16.0.10751
  • SQL Compare engine: 15.0.14.23802
  • Compare for Oracle engine: 6.1.1.1708
  • Electron: 26.1.0

6.5.13 - 24 August 2023

Fixes

  • Fixed a bug in the Flyway project importer where specifying the ‘destination’ flag leads to an incorrect in-place import
  • Fixed an issue with cloning repositories on Windows

Library Versions

  • Flyway: 9.21.2
  • RG Compare: 1.15.2.10683
  • SQL Compare engine: 15.0.13.23786
  • Compare for Oracle engine: 6.1.1.1686
  • Electron: 26.1.0

6.5.12 - 22 August 2023

Fixes

  • Error message improved if git clone is attempted without git installed

Library Versions

  • Flyway: 9.21.1
  • RG Compare: 1.15.2.10656
  • SQL Compare engine: 15.0.13.23786
  • Compare for Oracle engine: 6.1.1.1686
  • Electron: 26.0.0

6.5.11 - 21 August 2023

Improvements

  • flyway-dev command line generate and next-migration-name verbs can now handle major and minor version increments via the optional --increment parameter
  • Renamed log in to sign in in UI for consistency

Changes

  • flyway-dev command line generate verb no longer generates undo scripts for baseline migrations

Fixes

  • Fixed issue where error messages might not display correctly
  • Fixed UI glitch where it might appear that a password had already been set when switching between auth types in SQL Server

Library Versions

  • Flyway: 9.21.1
  • RG Compare: 1.15.2.10618
  • SQL Compare engine: 15.0.13.23786
  • Compare for Oracle engine: 6.1.1.1686
  • Electron: 26.0.0

6.5.10 - 09 August 2023

Improvements

  • Improvements to accessibility and keyboard navigation in landing page area

Library Versions

  • Flyway: 9.21.1
  • RG Compare: 1.15.2.10497
  • SQL Compare engine: 15.0.12.23725
  • Compare for Oracle engine: 6.1.1.1677
  • Electron: 25.4.0

6.5.9 - 08 August 2023

Fixes

  • Fixed an issue where the database description in the app footer was expanding to full width

Library Versions

  • Flyway: 9.21.1
  • RG Compare: 1.15.2.10497
  • SQL Compare engine: 15.0.11.23722
  • Compare for Oracle engine: 6.1.0.1675
  • Electron: 25.4.0

6.5.8 - 03 August 2023

Changes

  • Git branch dropdown list will no longer display remote branches tracked by existing corresponding local branch

Fixes

  • Fixed an issue when upgrading projects to TOML that have a schema but no URL defined
  • Fixed an issue where hitting enter inside a search bar would refresh the application.

Library Versions

  • Flyway: 9.21.1
  • RG Compare: 1.15.2.10455
  • SQL Compare engine: 15.0.11.23713
  • Compare for Oracle engine: 6.0.24.1654
  • Electron: 25.4.0

6.5.7 - 02 August 2023

Improvements

  • Add Migrations tab now remembers any inputted version number when switching between migration types

Changes

  • Change appearance of target database lookup in Create a baseline script modal
  • Manually added migrations now also get given a default description like generated migrations

Fixes

  • Fixed an issue where the Windows installer would leave old files around after an update
  • Fixed an issue when upgrading to TOML with no .gitignore file present

Library Versions

  • Flyway: 9.21.1
  • RG Compare: 1.15.2.10409
  • SQL Compare engine: 15.0.11.23711
  • Compare for Oracle engine: 6.0.24.1645
  • Electron: 25.3.2

6.5.6 - 01 August 2023

New Features

  • It is now possible to start server-side trials on Linux & Mac for teams & enterprise editions. If you have already logged in to flyway desktop, you will need to sign out and sign in again to see available trials.

Improvements

  • Improved navigability of app header menus
  • The ID field in the connection dialogue now shows as invalid when it contains invalid characters

Fixes

  • Correct diff will be shown when selecting a row in the schema model tab when “Apply to database” is selected.
  • Fixed an issue preventing baselining from completing due to an unknown ID

Library Versions

  • Flyway: 9.21.1
  • RG Compare: 1.15.2.10399
  • SQL Compare engine: 15.0.10.23691
  • Compare for Oracle engine: 6.0.24.1607
  • Electron: 25.3.2

6.5.5 - 27 July 2023

Library Versions

  • Flyway: 9.21.1
  • RG Compare: 1.15.1.10347
  • SQL Compare engine: 15.0.10.23667
  • Compare for Oracle engine: 6.0.24.1599
  • Electron: 25.3.2

6.5.4 - 26 July 2023

New Features

  • It is now possible to track static data for Oracle databases during baseline step or alongside table creation. You may need to set the Include Source Tables data option to true, if it is not already enabled.

Improvements

  • Improved handling of selecting .user.toml file on open project. Flyway Desktop will now retry by stripping .user from filename.
  • Table keyboard navigation now updates diff viewer on Schema Model and Generate Migrations tabs
  • A search bar in the Manage Migrations tab allows you to filter results by version and description.

Library Versions

  • Flyway: 9.21.0
  • RG Compare: 1.15.0.10313
  • SQL Compare engine: 15.0.10.23667
  • Compare for Oracle engine: 6.0.24.1592
  • Electron: 25.3.1

6.5.3 - 25 July 2023

Improvements

  • Added a button to conveniently copy the version number of migrations on the Migrations tab.

Fixes

  • Fixed an issue where a subset of telemetry events were sent when REDGATE_DISABLE_TELEMETRY was configured
  • Fixed an issue preventing settings from being saved

Library Versions

  • Flyway: 9.21.0
  • RG Compare: 1.14.1.10266
  • SQL Compare engine: 15.0.10.23667
  • Compare for Oracle engine: 6.0.24.1559
  • Electron: 25.3.1

6.5.2 - 24 July 2023

Changes

  • Licensing pages now show when trials are unavailable

Fixes

  • The Flyway config parameter check.buildPassword is now correctly masked in the UI.
  • Fixed an issue where some comparison settings weren’t being preserved when upgrading from JSON to TOML

Library Versions

  • Flyway: 9.21.0
  • RG Compare: 1.14.1.10252
  • SQL Compare engine: 15.0.10.23658
  • Compare for Oracle engine: 6.0.24.1559
  • Electron: 25.3.1

6.5.1 - 20 July 2023

New Features

  • Invalid objects are now detected and automatically filtered out on baseline for SQL Server and Oracle by updating the filter file (SQL Server) or ignore rules file (Oracle)

Improvements

  • It is now possible to click connection modal Test and Save button and see highlighted required fields, instead of the button being disabled in this scenario

Fixes

  • Fixed issue with Mac “Install updates on exit” being unreliable
  • Improved error handling for incorrect remote VCS URLs when adding remote

Library Versions

  • Flyway: 9.20.1
  • RG Compare: 1.14.1.10226
  • SQL Compare engine: 15.0.10.23607
  • Compare for Oracle engine: 6.0.24.1559
  • Electron: 25.3.0

6.5.0 - 13 July 2023

New Features

  • Flyway Desktop is now available for linux platforms as a preview version.
  • New projects will be created in the new unified settings format, in TOML
  • Added a ‘prune’ option in the Version Control tab for branch clean-up during remote pulls.

Improvements

  • Buttons no longer change size when displaying a loading spinner

Library Versions

  • Flyway: 9.20.1
  • RG Compare: 1.14.1.10156
  • SQL Compare engine: 15.0.10.23607
  • Compare for Oracle engine: 6.0.24.1559
  • Electron: 25.3.0

6.4.5 - 11 July 2023

New Features

  • Having a schema shadowed by another on the same MySQL instance is now supported.
  • It is now possible to configure comparison options and data comparison options from the UI for SQL Server and Oracle

Improvements

  • Improved look & feel of Schema model’s and Generate migrations’ diff tables

Library Versions

  • Flyway: 9.20.0
  • RG Compare: 1.13.2.10098
  • SQL Compare engine: 15.0.10.23607
  • Compare for Oracle engine: 6.0.24.1529
  • Electron: 25.2.0

6.4.4 - 06 July 2023

Fixes

  • Fix scroll bar not appearing on generate migrations tab

Library Versions

  • Flyway: 9.20.0
  • RG Compare: 1.13.0.10057
  • SQL Compare engine: 15.0.10.23603
  • Compare for Oracle engine: 6.0.24.1498
  • Electron: 25.2.0

6.4.3 - 04 July 2023

New Features

  • There is now a Commit and push option on the version control page

Improvements

  • Flyway parameters added on the Migrations tab are now automatically saved
  • Update banners now appear below the app’s title bar

Fixes

  • Fixed an issue where the commit card overlayed the bottom of the changes table, hiding some changes

Library Versions

  • Flyway: 9.20.0
  • RG Compare: 1.13.0.10035
  • SQL Compare engine: 15.0.10.23590
  • Compare for Oracle engine: 6.0.24.1498
  • Electron: 25.2.0

6.4.2 - 28 June 2023

Fixes

  • Fixed an issue where Flyway Desktop errored when switching between Saving and Applying on the Schema Model tab

Library Versions

  • Flyway: 9.20.0
  • RG Compare: 1.12.3.9948
  • SQL Compare engine: 15.0.10.23590
  • Compare for Oracle engine: 6.0.24.1498
  • Electron: 25.2.0

6.4.1 - 27 June 2023

Improvements

  • The DropAndCreateInsteadOfAlter SQL Server comparison option is no longer hard-coded and can be configured in the project settings file

Library Versions

  • Flyway: 9.20.0
  • RG Compare: 1.12.3.9948
  • SQL Compare engine: 15.0.10.23590
  • Compare for Oracle engine: 6.0.24.1487
  • Electron: 25.2.0

6.4.0 - 26 June 2023

New Features

  • A new permit licensing system has been enabled for mac platforms. You will now be asked to either log in with your Red Gate account (online activation) or provide an offline license permit through the application (offline activation).

Improvements

  • Display error message when attempting to open migration files without supported encoding
  • Remove clutter and change look & feel of diff view in schema model tab

Fixes

  • Fixed an issue where reloading a project doesn’t reload the Migrations tab

Library Versions

  • Flyway: 9.20.0
  • RG Compare: 1.12.3.9948
  • SQL Compare engine: 15.0.10.23590
  • Compare for Oracle engine: 6.0.24.1457
  • Electron: 25.2.0

6.3.23 - 22 June 2023

Library Versions

  • Flyway: 9.20.0
  • RG Compare: 1.12.3.9923
  • SQL Compare engine: 15.0.10.23589
  • Compare for Oracle engine: 6.0.24.1457
  • Electron: 25.2.0

6.3.22 - 20 June 2023

New Features

  • Added a ‘dryrun’ option for the Check command on the Migrations tab

Improvements

  • Removed clutter from version control page
  • Revamped the header with icons instead of a single dropdown

Changes

  • Target Databases page is now a modal

Fixes

  • Fixed an issue where the extension was displayed twice when adding a migration
  • Fixed an issue where the display name for databases was not shown in the UI
  • Fixed an issue where applying migrations to Shadow would fail due to Clean not being enabled
  • Fixed an issue where not all schemas were being cleaned in SQL Server

Library Versions

  • Flyway: 9.20.0
  • RG Compare: 1.12.2.9897
  • SQL Compare engine: 15.0.10.23589
  • Compare for Oracle engine: 6.0.24.1456
  • Electron: 25.1.1

6.3.21 - 13 June 2023

Changes

  • Removed header and description text on some tabs to free additional vertical space.

Library Versions

  • Flyway: 9.19.4
  • RG Compare: 1.11.4.9739
  • SQL Compare engine: 15.0.10.23583
  • Compare for Oracle engine: 6.0.24.1435
  • Electron: 25.1.0

6.3.20 - 09 June 2023

Improvements

  • Licensing management UI and editions cards have been updated

Fixes

  • Fixed an issue where the link to the generated Flyway report would not open
  • Fixed an issue where an error could occur when cleaning SQL Server databases

Library Versions

  • Flyway: 9.19.4
  • RG Compare: 1.11.4.9701
  • SQL Compare engine: 15.0.10.23576
  • Compare for Oracle engine: 6.0.24.1426
  • Electron: 25.1.0

6.3.19 - 08 June 2023

Fixes

  • Fixed an issue where baselining an empty Oracle database caused an error due to the Baseline script not existing

Library Versions

  • Flyway: 9.19.3
  • RG Compare: 1.11.3.9673
  • SQL Compare engine: 15.0.10.23565
  • Compare for Oracle engine: 6.0.24.1426
  • Electron: 25.1.0

6.3.18 - 30 May 2023

Improvements

  • Always refresh migrations on the Migrations tab after a command fails to complete
  • Whenever Flyway commands produce a report they will be linked to after the command runs on the Migrations tab
  • Disable the ‘Create baseline’ button once it’s clicked to avoid running multiple times

Changes

  • Changed tooltip look and feel
  • Set baselineOnMigrate to true when setting baselineVersion to remove a failure point when applying to non-empty target databases

Fixes

  • Fixed tooltips rendering behind table headers
  • Allow editing target connection details from the Baseline modal
  • Fixed an issue preventing the creation of SingleStore projects
  • Fixed an issue where the changes table could show duplicate rows if it included data and schema differences for the same table.

Library Versions

  • Flyway: 9.19.1
  • RG Compare: 1.11.2.9453
  • SQL Compare engine: 15.0.9.23488
  • Compare for Oracle engine: 6.0.23.1360
  • Electron: 25.0.0

6.3.17 - 23 May 2023

Library Versions

  • Flyway: 9.18.0
  • RG Compare: 1.11.2.9383
  • SQL Compare engine: 15.0.8.23472
  • Compare for Oracle engine: 6.0.23.1321
  • Electron: 24.3.1

6.3.16 - 22 May 2023

Library Versions

  • Flyway: 9.18.0
  • RG Compare: 1.11.2.9357
  • SQL Compare engine: 15.0.8.23434
  • Compare for Oracle engine: 6.0.23.1318
  • Electron: 24.3.1

6.3.15 - 18 May 2023

Improvements

  • Git clone modal now warns user if target directory exists and is not empty before closing modal
  • Previous target directories are remembered and auto-filled in clone modal
  • Suggested project directory name is extracted from clone URL

Changes

  • Tweaked modal appearance
  • Normalized button order on modals, cancel is now always right-most button

Fixes

  • Git clone no longer hangs indefinitely under authentication issues, this scenario now prompts the user and stops the process

Library Versions

  • Flyway: 9.18.0
  • RG Compare: 1.11.2.9318
  • SQL Compare engine: 15.0.8.23434
  • Compare for Oracle engine: 6.0.23.1286
  • Electron: 24.3.1

6.3.14 - 16 May 2023

Fixes

  • Fixed available trials not correctly refreshing

Library Versions

  • Flyway: 9.18.0
  • RG Compare: 1.11.2.9262
  • SQL Compare engine: 15.0.8.23434
  • Compare for Oracle engine: 6.0.23.1276
  • Electron: 24.3.0

6.3.13 - 16 May 2023

Changes

  • Manage static data button has been renamed to Static data & comparisons in preparation for making comparison options configurable in the UI

Fixes

  • Fixed an issue where large numbers of migrations weren’t all displayed on the Migrations tab

Library Versions

  • Flyway: 9.17.0
  • RG Compare: 1.11.2.9262
  • SQL Compare engine: 15.0.8.23434
  • Compare for Oracle engine: 6.0.23.1276
  • Electron: 24.3.0

6.3.12 - 10 May 2023

New Features

  • Script warnings are now displayed when generating migrations

Improvements

  • Migration table items are now navigable via arrow keys

Fixes

  • Fixed an issue where configuring a custom database driver would cause unrelated connections to use that driver

Library Versions

  • Flyway: 9.17.0
  • RG Compare: 1.11.2.9199
  • SQL Compare engine: 15.0.8.23423
  • Compare for Oracle engine: 6.0.23.1229
  • Electron: 24.2.0

6.3.11 - 05 May 2023

New Features

  • Flyway config is now automatically generated to suppress transactions when generating migrations for SQL Server objects which cannot be run in transactions

Improvements

  • Slightly improved UI of migration name display when editing scripts
  • Added default display names for the development database and shadow database
  • Added Undo Migrations use the defined separator in the version instead of a dot

Fixes

  • Undo scripts will now be generated correctly against migration scripts which both create a table and populate it with static data
  • Addressed some performance issues checking the status of the shadow database and fetching the list of migrations

Library Versions

  • Flyway: 9.17.0
  • RG Compare: 1.11.2.9177
  • SQL Compare engine: 15.0.8.23423
  • Compare for Oracle engine: 6.0.23.1190
  • Electron: 24.2.0

6.3.10 - 04 May 2023

Improvements

  • App displays loading spinner when opening project from file explorer view

Library Versions

  • Flyway: 9.17.0
  • RG Compare: 1.11.2.9156
  • SQL Compare engine: 15.0.8.23423
  • Compare for Oracle engine: 6.0.23.1184
  • Electron: 24.2.0

6.3.9 - 03 May 2023

Improvements

  • The migrations list is now refreshed automatically when cherryPick or locations parameters are set

Library Versions

  • Flyway: 9.17.0
  • RG Compare: 1.11.2.9138
  • SQL Compare engine: 15.0.8.23417
  • Compare for Oracle engine: 6.0.23.1179
  • Electron: 24.1.3

6.3.8 - 27 April 2023

Improvements

  • Logs now include the reason why the shadow database was cleaned

Library Versions

  • Flyway: 9.15.2
  • RG Compare: 1.11.1.9091
  • SQL Compare engine: 15.0.8.23414
  • Compare for Oracle engine: 6.0.23.1156
  • Electron: 24.1.3

6.3.7 - 25 April 2023

Fixes

  • Fixed link to generated report shown after flyway check command

Library Versions

  • Flyway: 9.15.2
  • RG Compare: 1.11.0.9032
  • SQL Compare engine: 15.0.8.23400
  • Compare for Oracle engine: 6.0.23.1156
  • Electron: 24.1.2

6.3.6 - 24 April 2023

New Features

  • Added support for SingleStore database project types

Fixes

  • Baseline migrations will now no longer be created with create schema definitions.
  • Fixed an issue where the end of a large diff may not be displayed

Library Versions

  • Flyway: 9.15.2
  • RG Compare: 1.11.0.9032
  • SQL Compare engine: 15.0.8.23400
  • Compare for Oracle engine: 6.0.23.1156
  • Electron: 24.1.2

6.3.5 - 20 April 2023

Changes

  • Display name has been moved to the top of the connection dialog
  • “Check” can no longer be run on the Migrations tab without selecting one of the options

Fixes

  • Fixed issue where the Flyway command preview on the migrations tab would not update after adding a parameter
  • Fixed an issue where installing or updating on Mac would prevent FWD from communicating with necessary services. This was affecting non-admin users using the application, and would require a reinstall.
  • Fixed an issue where errors were reported immediately after initializing a Git repository
  • Fixed an issue where dismissing the update banner wasn’t working, and the banner would return

Library Versions

  • Flyway: 9.15.2
  • RG Compare: 1.10.2.9012
  • SQL Compare engine: 15.0.8.23400
  • Compare for Oracle engine: 6.0.23.1130
  • Electron: 24.1.2

6.3.4 - 13 April 2023

Fixes

  • Fixed an issue where connection testing fails if you enable the Flyway option “failOnMissingLocations”

Library Versions

  • Flyway: 9.15.2
  • RG Compare: 1.9.2.8969
  • SQL Compare engine: 15.0.8.23398
  • Compare for Oracle engine: 6.0.22.1105
  • Electron: 24.1.0

6.3.3 - 12 April 2023

Improvements

  • The shadow database will now be cleaned if any migrations have changed since it was last updated.

Fixes

  • Fixed stray character which sometimes appeared next to “Clean and retry” button on the generate migrations error page
  • Fixed issue where switching between diffs in the schema model page would result in a “lineNumber” error
  • Fixed issue where properties might get removed unexpectedly when manually editing a JDBC URL

Library Versions

  • Flyway: 9.15.2
  • RG Compare: 1.9.2.8951
  • SQL Compare engine: 15.0.8.23385
  • Compare for Oracle engine: 6.0.22.1105
  • Electron: 24.1.0

6.3.2 - 06 April 2023

Improvements

  • Schema diffs now appear in the diff tables on schema model and generate migrations tabs

Library Versions

  • Flyway: 9.15.2
  • RG Compare: 1.9.2.8923
  • SQL Compare engine: 15.0.8.23384
  • Compare for Oracle engine: 6.0.21.1097
  • Electron: 24.0.0

6.3.1 - 04 April 2023

Fixes

  • Fixed issue with recent projcets list being empty since opening projects requires selecting a flyway-dev.json instead of a folder

Library Versions

  • Flyway: 9.15.2
  • RG Compare: 1.9.2.8859
  • SQL Compare engine: 15.0.8.23384
  • Compare for Oracle engine: 6.0.21.1081
  • Electron: 23.2.1

6.3.0 - 03 April 2023

Breaking Changes

  • Opening existing projects now requires selecting a flyway-dev.json file instead of selecting a folder which contains this file. Opening recent projects will continue to work as before. The flyway-dev command lines will continue to work passing in a folder as a project for now, though it is recommended to pass in the project file path instead, and this will be required in the future.

Improvements

  • The names of the projects in the recent projects list will now match the project name rather than the project folder name
  • Made the error messaging around baselining against an empty target more detailed

Fixes

  • It is now possible to easily retry baseline generation following an error generating the script
  • Fixed an issue where the regenerate baseline button might show up erroneously on errors applying migrations to the shadow database

Library Versions

  • Flyway: 9.15.2
  • RG Compare: 1.9.2.8859
  • SQL Compare engine: 15.0.8.23384
  • Compare for Oracle engine: 6.0.21.1081
  • Electron: 23.2.1

6.2.1 - 30 March 2023

Fixes

  • Fixed update available banner not being dismissed

Library Versions

  • Flyway: 9.15.2
  • RG Compare: 1.9.1.8835
  • SQL Compare engine: 15.0.8.23370
  • Compare for Oracle engine: 6.0.21.1077
  • Electron: 23.2.0

6.2.0 - 29 March 2023

Improvements

  • MySQL connections can now be added through an intuitive dialog by typing in the server, port etc without needing a JDBC URL

Fixes

  • Fixed issue where processes may spawn which don’t terminate

Library Versions

  • Flyway: 9.15.2
  • RG Compare: 1.9.1.8812
  • SQL Compare engine: 15.0.8.23362
  • Compare for Oracle engine: 6.0.21.1077
  • Electron: 23.2.0

6.1.9 - 28 March 2023

Fixes

  • Fixes issue where updating the migration name or content of a generated migration would reset changes in the other

Library Versions

  • Flyway: 9.15.2
  • RG Compare: 1.9.0.8808
  • SQL Compare engine: 15.0.8.23362
  • Compare for Oracle engine: 6.0.21.1074
  • Electron: 23.2.0

6.1.8 - 27 March 2023

Fixes

  • Fixed issue where warning that no git remotes have been configured might appear erroneously when a git fetch failed

Library Versions

  • Flyway: 9.15.2
  • RG Compare: 1.9.0.8782
  • SQL Compare engine: 15.0.8.23332
  • Compare for Oracle engine: 6.0.21.1071
  • Electron: 23.2.0

6.1.7 - 22 March 2023

Improvements

  • Add option to select how frequently the app will raise notifications about patch updates

Fixes

  • Fixed a parsing issue when generating migrations.

Library Versions

  • Flyway: 9.15.2
  • RG Compare: 1.9.0.8755
  • SQL Compare engine: 15.0.8.23311
  • Compare for Oracle engine: 6.0.20.1039
  • Electron: 23.1.4

6.1.6 - 20 March 2023

New Features

  • It is now possible to add a remote via the UI when there is none configured
  • It is now possible to initialize a git repository in a prent directory
  • There is now a prompt to configure static data (if desired) before baselining

Improvements

  • There is now an option to regenerate the baseline when there is a failure deploying the baseline script to the shadow database
  • The encoding setting in flyway.conf is now honoured when adding or generating migration scripts
  • The static data configuration modal should now be much more responsive when interacting with large databases.

Fixes

  • Prevent “No updates found” banner from appearing in certain cases on automatic update checks
  • Reopening an Azure active directory interactive connection dialog, will now correctly show the authentication type with the existing tenant id and client id

Library Versions

  • Flyway: 9.16.0
  • RG Compare: 1.9.0.8718
  • SQL Compare engine: 15.0.8.23281
  • Compare for Oracle engine: 6.0.20.1039
  • Electron: 23.1.4

6.1.5 - 15 March 2023

Improvements

  • Added additional debug logging for errors coming from comparison engines

Fixes

  • Fixed default extension restriction list when browsing for existing files when adding a migration

Library Versions

  • Flyway: 9.15.2
  • RG Compare: 1.9.0.8697
  • SQL Compare engine: 15.0.8.23281
  • Compare for Oracle engine: 6.0.20.1018
  • Electron: 23.1.3

6.1.4 - 08 March 2023

Improvements

  • Migrations tab now displays helpful message to user if no migrations are currently part of project
  • Added a button to copy generated script content to clipboard.
  • Adding locations parameter on migrations page will now be honoured in listing migrations (following refresh)

Changes

  • Generated display names will now be saved to the project settings
  • Form for entering Flyway parameters no longer has a leading ‘=’ for values

Fixes

  • Fixed issue where an error is raised when generating migrations and the migrations folder does not exist
  • Fixed issue where an added Undo Migration is displayed as a Versioned Migration
  • Fixed issue where selecting a migration to undo doesn’t update the UI
  • Fixed issue where target database state on the migrations page might be stale after editing a target database
  • Fixed issue where generated Baseline Migrations were being saved as Versioned Migrations

Library Versions

  • Flyway: 9.15.2
  • RG Compare: 1.8.1.8555
  • SQL Compare engine: 15.0.7.23275
  • Compare for Oracle engine: 6.0.20.982
  • Electron: 23.1.2

6.1.3 - 28 February 2023

New Features

  • Static data tracking is now possible for SQL Server baseline script generation
  • Static data tracking is now possible for tables yet to be created in the target of a comparison

Fixes

  • Fixed issue saving shadow database to project settings when using local credential storage and no shadow configuration in the user file
  • Fixed issue on SQL Server connection dialog when clearing instance and JDBC url retaining empty instanceName query parameter

Library Versions

  • Flyway: 9.15.1
  • RG Compare: 1.8.1.8422
  • SQL Compare engine: 15.0.6.23226
  • Compare for Oracle engine: 6.0.17.858
  • Electron: 23.1.1

6.1.2 - 21 February 2023

New Features

  • Placeholders can now be configured through the UI

Improvements

  • Tables on Schema Model and Generate Migrations tabs can now be filtered based on object type and on schema
  • Generated Undo scripts have UNDO- prefixed to their descriptions to better distinguish them from their Version script counterparts
  • Static data diffs now trim whitespace from columns

Library Versions

  • Flyway: 9.15.0
  • RG Compare: 1.8.1.8314
  • SQL Compare engine: 15.0.5.23181
  • Compare for Oracle engine: 6.0.17.858
  • Electron: 23.1.0

6.1.1 - 15 February 2023

Improvements

  • Split migration script name into version and description fields on Generate migrations tab
  • Keep undo script names in sync with migration script names on Generate migrations tab

Fixes

  • Fixed issue when clicking on Apply to database radio button with no development database set
  • Fixed issue where Azure MFA prompted for sign-in on every connection due to no token being retrieved and cached

Library Versions

  • Flyway: 9.14.1
  • RG Compare: 1.8.1.8205
  • SQL Compare engine: 15.0.5.23167
  • Compare for Oracle engine: 6.0.17.858
  • Electron: 23.0.0

6.1.0 - Feb 8th, 2023

Breaking Changes

  • Windows versions 7/8/8.1 are no longer supported by Flyway Desktop.

Fixes

  • Users can now start Flyway Desktop Community edition.

Library Versions

  • Updated RgCompare to 1.7.2.8066

6.0.4 - Feb 1st, 2023

New Features

  • Flyway Desktop now displays a prompt asking to generate Undo scripts when generating your first Migration

Improvements

  • flyway.baselineVersion is now automatically updated in flyway configuration on baseline script generation
  • Shadow migration will now clean automatically if the first migrate attempt fails due to a non-empty schema.

Library Versions

  • Updated SQL Compare to 15.0.4
  • Updated RgCompare to 1.7.1.7909
  • Updated Flyway to 9.14.1

6.0.3 - Jan 18th, 2023

Changes

  • Improved reporting of errors in the “Manage static data” modal.

Library Versions

  • Updated SQL Compare to 15.0.3
  • Updated RgCompare to 1.7.1.7682

6.0.2 - Jan 16th, 2023

Improvements

  • Configuration modal now displays schemas used for shadow database

Fixes

  • Static data modal is now not closed when clicking away from it
  • Fix timeout when sending telemetry encounters a large network delay
  • Removed unnecessary scroll bars from the ‘Schema model’ and ‘Generate migration’ pages
  • Prevented the diff viewer from opening when objects are selected on the ‘Schema model’ and ‘Generate migration’ pages

Library Versions

  • Updated SQL Compare to 15.0.2
  • Updated RgCompare to 1.7.1

6.0.1 - Jan 11th, 2023

Improvements

  • Added scrollbar for long schema update/project migration summaries

Fixes

  • Fixed issue where development database would display with an empty name if the display name was removed
  • Fixed issue where Azure Active Directory Universal with MFA connections would fail

Library Updates

  • Updated flyway engine to 9.11.0
  • Updated SQL Compare engine to version 15.0.1.22876

6.0.0 - Dec 28th, 2022

New Features

  • Static data comparison is now out of preview for Oracle and SQL Server
  • It is now possible to configure tables to track for static data, from the Schema model page

Fixes

  • It is now possible to generate undo scripts for static data changes for SQL Server
  • Fixed issue where a toast error message would reappear despite being dismissed, when flyway-dev.json for an open project was updated to be invalid json

Library Updates

  • Updated flyway engine to 9.10.2
  • Updated SQL Compare engine to version 15.0.1.22813
  • Updated Compare for Oracle engine to version 6.0.17.858

Didn't find what you were looking for?

Product Articles

Tips and how-to guides for Redgate products

University

Easy to follow video courses

Community Forums

Ask, discuss, and solve questions about Redgate's tools

Events & Friends

Meet us at an event, get sponsored, and join our Friends of Redgate

Simple Talk

In-depth articles and opinion from Redgate's technical journal