Features

• 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.

Fixes

• Fixed scrolling on Schema model and Generate migrations tabs.

Features

• Added filtering to invalid objects table.
• 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.

Fixes

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

Features

• 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.
• 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.

Fixes

• Default development database name set on flyway.conf import.

Features

• When adding a new migration, the script editor now automatically has focus.
• 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.

Fixes

• Fixed an issue where the Schema Model Apply summary wouldn’t scroll.
• The baseline process will no longer fail on invalid object detection issues.

Features

• A new redgateCompare.mysql.options.ignores.ignoreNewlinesInTextObjects option 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.
• 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.

Fixes

• Fixed copy and expand actions being rendered off the edge of connection error banner.
• Fixed an issue where serializing comparison artifacts could lead to out of memory exceptions.
• The baseline process will no longer fail on invalid object detection issues.

Features

• Change: Set data compare option forceBinaryCollation to false by default.
• 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.

Fixes

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

Features

• The MySQL "Edit Connection" dialog can now recognize 'jdbc:mariadb:..' urls, including the 'usePipelineAuth' and 'useBatchMultiSend' properties required for connecting to Aurora MySQL.
• 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.

Fixes

• Increased timeout on sign-in option.

Features

• 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.

Features

• 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.

Features

• 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.

Fixes

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

Features

• 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.

Features

• Flyway Desktop will now remember previously used locations for creating projects, matching the clone from version control form behavior.
• New Offline Licensing workflow is now enabled on Microsoft Windows.
• It is now possible to trial Teams and Enterprise editions of Flyway Desktop as two separate trials.
• 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.
• 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.

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.
• Updated Flyway Engine to fix configuration disclosure in extended debug output.

Features

• Environment IDs are now visible but editing is 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 the environment parameter is set.
• 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.

Features

• 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.

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.

Features

• 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.

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.

Features

• Open project dialog now displays a helpful message on Apple macOS.
• 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.

Features

• 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.
• 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.

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.

Features

• Added a copy to clipboard button for the JDBC URL field.
• 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.

Fixes

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

Features

• 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.

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.

Features

• 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.

Fixes

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

Features

• '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.

Features

• Improved 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.

Features

• 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.

Fixes

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

Features

• Git branch dropdown list will no longer display remote branches tracked by existing corresponding local branch.
• 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.

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.

Features

• The 'Add Migrations' tab now remembers any inputted version number when switching between migration types.
• Changed appearance of target database lookup in Create a baseline script modal.
• Manually added migrations now also get given a default description like generated migrations.
• Library Versions:
  • Flyway: 9.21.1.
  • RG Compare: 1.15.2.10409.
  • SQL Compare engine: 15.0.11.23711.
  • Compare for Oracle engine: to 6.0.24.1645.
  • Electron: 25.3.2.

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.

Features

• It is now possible to start server-side trials on Linux and Apple Mac for teams and 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.
• Improved navigability of app header menus.
• The ID field in the connection dialogue now shows as invalid when it contains invalid characters.
• 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.

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.

Features

• 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.

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.
• 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.
• Added a search bar in the Manage Migrations tab which 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.

Features

• Added a button to conveniently copy the version number of migrations on the Migrations tab.
• 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.

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.

Features

• Licensing pages now show when trials are unavailable.
• 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.

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.

Features

• Invalid objects are now detected and automatically filtered out on baseline for Microsoft SQL Server and Oracle by updating the filter file (SQL Server) or ignore rules file (Oracle).
• 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.
• 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.

Fixes

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

Features

• Flyway Desktop is now available for linux platforms as a preview version.
• New projects will now 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.
• 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.

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 Microsoft SQL Server and Oracle.
• Improved look and 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.

Features

• 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.

Fixes

• Fixed scroll bar not appearing on generate migrations tab.

Features

• Added a 'Commit and push' option on the version control page.
• Flyway parameters added on the Migrations tab are now automatically saved.
• Update banners now appear below the app's title bar.
• 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.

Fixes

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

Features

• 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.

Fixes

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

Features

• The DropAndCreateInsteadOfAlter Microsoft 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.

Features

• A new permit licensing system has been enabled for Apple 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).
• You can now display error message when attempting to open migration files without supported encoding.
• Removed clutter and changed look and feel of diff view in 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.1457.
  • Electron: 25.2.0.

Fixes

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

Features

• 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.

Features

• Added a ‘dryrun’ option for the Check command on the Migrations tab.
• Removed clutter from version control page.
• Revamped the header with icons instead of a single dropdown.
• Target Databases page is now a modal.
• 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.

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.

Features

• 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.

Features

• Licensing management UI and editions cards have been updated.
• 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.

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.

Features

• 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.

Fixes

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

Features

• Migrations are now refreshed after a command fails to complete.
• Whenever Flyway commands produce a report, they will now be linked-to after the command runs.
• Disabled the 'Create baseline' button once it's clicked to avoid running multiple times.
• Changed tooltip look and feel.
• Set 'baselineOnMigrate' to true when setting 'baselineVersion' to remove a failure point when applying to non-empty target databases.
• 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.

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.

Features

• 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.

Features

• 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.

Features

• Git clone modal now warns user if target directory exists and is not empty before closing modal.
• Previous target directories are now remembered and auto-filled in clone modal.
• Suggested project directory name is now extracted from clone URL.
• Tweaked modal appearance.
• Normalized button order on modals, cancel is now always right-most button.
• 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.

Fixes

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

Features

• 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.

Fixes

• Fixed available trials not correctly refreshing.

Features

• The 'Manage static data' button has been renamed to 'Static data & comparisons' in preparation for making comparison options configurable in the UI.
• 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.

Fixes

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

Features

• Script warnings are now displayed when generating migrations.
• Migration table items are now navigable via arrow keys.
• 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.

Fixes

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

Features

• Flyway config is now automatically generated to suppress transactions when generating migrations for Microsoft SQL Server objects which cannot be run in transactions.
• Improved UI of migration name display when editing scripts.
• Added default display names for development database and shadow database.
• Undo Migrations now use the defined separator in the version instead of a dot.
• 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.

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.

Features

• The App now displays loading spinner when opening a 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.

Features

• 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.

Features

• 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.

Features

• 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.

Fixes

• Fixed link to generated report shown after flyway check command.

Features

• Added support for SingleStore database project types.
• 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.

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.

Features

• 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.
• 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.

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.

Features

• 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.

Fixes

• Fixed an issue where connection testing fails if you enable the Flyway option "failOnMissingLocations".

Features

• The shadow database will now be cleaned if any migrations have changed since it was last updated.
• 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.

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.

Features

• 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.

Fixes

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

Features

• 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.

Fixes

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

Features

• 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.
• Breaking Change - 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.
• 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.

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.

Features

• 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.

Fixes

• Fixed update available banner not being dismissed.

Features

• MySQL connections can now be added through an intuitive dialog by typing in the server, port etc without needing a JDBC URL.
• 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.

Fixes

• FFixed issue where processes may spawn which don’t terminate.

Features

• RG Compare: 1.9.0.8808.
• SQL Compare engine: 15.0.8.23362.
• Compare for Oracle engine: 6.0.21.1074.

Fixes

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

Features

• 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.

Fixes

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

Features

• Added the option to select how frequently the app will raise notifications about patch updates.
• 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.

Fixes

• Fixed a parsing issue when generating migrations.

Features

• It is now possible to add a Git remote via the UI when there is none configured.
• It is now possible to initialize a Git repository in a parent directory.
• There is now a prompt to configure static data (if desired) before baselining.
• There is now an option to regenerate a baseline when there is a failure deploying the script to the shadow database.
• The encoding setting in flyway.conf is now honored when adding or generating migration scripts.
• The static data configuration modal should now be much more responsive when interacting with large databases.
• 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.

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.

Features

• Added additional debug logging for errors coming from comparison engines.
• 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.

Fixes

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

Features

• 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 honored in listing migrations following a refresh.
• Generated display names will now be saved to the project settings.
• Form for entering Flyway parameters no longer has a leading '=' for values.
• 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.

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.

Features

• Static data tracking is now available for Microsoft SQL Server baseline script generation.
• Static data tracking is now available for tables yet to be created in the target of a comparison.
• 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.

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.

Features

• Placeholders can now be configured through the UI.
• Tables on Schema Model and Generate Migrations tabs can now be filtered based on object type and on schema.
• Generated Undo scripts now 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.

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.

Features

• 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.
• 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.

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.

Features

• Microsoft Windows versions 7/8/8.1 are no longer supported.
• Library Versions:
  • RgCompare: 1.7.2.8066.

  Fixes

  • Users can now start Flyway Desktop Community edition.

Features

• Flyway Desktop now displays a prompt asking to generate Undo scripts when generating your first Migration.
• 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:
  • SQL Compare: 15.0.4.
  • RgCompare: 1.7.1.7909.
  • Flyway: 9.14.1.

Features

• Improved reporting of errors in the "Manage static data" modal.
• Library Versions:
  • SQL Compare: 15.0.3.
  • RgCompare: 1.7.1.7682.

Features

• Configuration window now displays schemas used for shadow databases.

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.

Features

• Added a scrollbar for long schema update/project migration summaries.
• Library Versions:
  • Flyway engine: 9.11.0.
  • SQL Compare engine: 15.0.1.22876.

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.

Features

• Static data comparison is now out of preview for Oracle and Microsoft SQL Server.
• It is now possible to configure tables to track for static data, from the Schema model page.
• Library Versions:
  • Flyway engine: 9.10.2.
  • SQL Compare engine: 15.0.1.22813.
  • Compare for Oracle engine: version 6.0.17.858.

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.