Features

• Clean no longer runs in a transaction so objects such as memory-optimized tables for Microsoft SQL Server can now be deleted correctly.
• Updated flyway engine to 9.10.1.
• Updated SQL Compare engine to version 14.10.10.22784.
• Updated Compare for Oracle engine to version 6.0.17.858.

Features

• Added support for putting shadow databases on the same database as development for single schema databases by allow editing of shadow schema in the UI.
• Updated flyway engine to 9.10.0.
• Updated SQL Compare engine to version 14.10.10.22681.
• Updated Compare for Oracle engine to version 6.0.17.847.
• Projects named using the redgate-change-control project naming convention are no longer automatically converted to flyway-dev.
• Automatic setting of the flyway.oracle.sqlplus property in old projects is no longer performed.
• Projects containing old style inline connections are no longer supported - projects should use UsernamePassword instead.

Fixes

• Schema changes are now handled alongside static data changes (though some schema changes may need to be resolved before static data changes are picked up).

Features

• Merge conflicts can now be resolved using the version control tab.
• Added a preview support for tracking static data for Oracle.
• It is now possible to run flyway check with the '-code' flag for code analysis on the migrations page (with SQLFluff installed).
• Updated Compare for Oracle engine to version 6.0.17.840.

Features

• Updated SQL Compare engine to version 14.10.8.22613.

Fixes

• Fixed issue with static data deployment script contents.

Features

• Updated Flyway engine to version 9.8.3.
• Updated SQL Compare engine to version 14.10.8.22550.
• Updated Compare for Oracle engine to version 6.0.17.827.

Fixes

• Fixed issue where static data scripts might be generated incorrectly when static data undo scripts are being generated, by disabling static data undo script generation. This feature will be restored in an upcoming release.

Features

• Added preview support for tracking static data in Microsoft SQL Server.
• Support for automatically selecting previously executed Flyway commands.

Fixes

• Resolved an issue where checkboxes would display incorrectly when a table was scrollable.

Features

• Flyway Desktop will now reload a project if the project's settings files have changed.

Fixes

• Fixed issue where link to output report would not work when performing flyway check.

Features

• Added previous/next buttons in diff panel.
• It is now possible to persist the database used for baselining and to select an existing target database when baselining.
• PostgreSQL object-level history and migration generation is now out of preview and generally available.
• Added the ability to adjust height of diff panel.
• Added loading spinner in branch dropdown when checking out.
• Branches which are deleted outside of application are now removed from branch dropdown on window focus.

Fixes

• Fixed the development database failing to show in the target databases dropdown (under the migrations tab) under certain conditions.
• Fixed branch filter.
• Fixed loading spinner in create branch modal.

Fixes

• Fixed credential information not always saving in the connection editor if the credential type changed as a result of pasting in a different URL.

Fixes

• Fixed issue where baseline message would not appear when using Oracle.

Features

• Added the ability to open projects from version control.

Fixes

• Fixed scenario that would cause the application to prompt for sign in after offline activation.

Features

• By default, only pending migrations are now shown on the migrations tab.

Fixes

• Long database display names are now truncated in the target databases table.

Features

• It is now possible to select the development database from the initial target database drop down on the manage migrations page.
• Improved timeliness of baseline check.
• The initial Add target database button on the manage migrations page now opens a connection dialog directly rather than showing the target databases page.

Fixes

• Fixed a bug where the baseline connection would fail for password authentication types in SQL Server.

Features

• Added Manage my license button to edition selection screen.
• Added success status message on the Generate Migrations page.
• Added prompt to verify migration following migration generation.
• The git branch dropdown will now expand to show longer branch names.
• The generate migrations tab now includes a descriptive header even when there is no connection.
• Updated Flyway to version 9.4.0.
• Updated Schema Compare for Oracle Engine to version 6.0.15.699.
• Updated SQL Compare Engine to version 14.10.4.21961.

Fixes

• Changing the file extension when adding a migration now changes the syntax highlighting in the editor.
• Fixed cases where the access token parameter to flyway would not be passed the correct value.
• Fixed bug where connection storage type was not pre-selected when switching between authentication types in SQL Server connection dialogs.

Features

• Headers now include a help tooltip that gives more descriptive information about a tab's purpose.

Fixes

• Fixed issue where authentication-specific fields were not showing up correctly on switching authentication type in SQL Server connection dialogs.

Fixes

• Fixed an error parsing output of flyway check command.

Features

• Added the ability to initialize a new repo in version control page.
• Improved resize behavior of icons and text in commit and differences tables.
• Git branches can now be deleted from the branch selector.
• Error banners now include a button to show the full error in a scrollable modal.
• The first versioned migration in a project will now start with V001 by convention.
• The migrations table is no longer automatically refreshed on adding a flyway parameter.
• Updated Schema Compare for Oracle Engine to version 6.0.14.652.
• Updated SQL Compare Engine to version 14.10.2.21876.
• Updated Flyway to version 9.3.1.

Fixes

• Flyway desktop will now clean up previous updates downloaded through check for updates.

Features

• Updated Schema Compare for Oracle Engine to version 6.0.13.620.
• Updated SQL Compare Engine to version 14.10.1.21778.

Fixes

• Restored the narrower row style in the Migrations table.
• Fixed misaligned version input box.
• Fixed some styling errors in Migration table.

Features

• Flyway Desktop can now be run in Community edition with a subset of features (preview).
• License key (masked) and edition now show up in flyway command view.
• Performance of the version control changes table has been improved.
• Hovering over migration states now provides a description of the state.
• The schema model and generate migrations tables have been updated to fit more content.
• Updated SQL Compare Engine to version 14.10.0.21762.
• Updated Schema Compare for Oracle Engine to version 6.0.13.614.
• Updated Flyway to version 9.3.0.

Fixes

• Fixed an issue where new projects weren't being added to the recent projects list.
• Made the migration description field on the Manage migrations page less restrictive, to allow all valid file names.
• Fixed error handling when failing to add a new migration so that add migration screen isn't closed.
• Empty connection dialog fields are no longer highlighted on opening connection dialog.
• Fixed error handling when "Clean and retry" fails on the generate migrations page.
• Importing an existing project will now open it unaltered.
• Fixed sorting of the state column in the Migrations table.
• Fixed potential error message overflow for errors displayed via a toast in the bottom right hand corner of the screen.

Fixes

• Fixed an incorrect message when pulling changes from version control.

Features

• Feedback link is now version specific.

Fixes

• Flyway check on the Migrations page now returns a more helpful result if no report type is specified.

Features

• It is now possible to choose to save database connections to the project settings (for version control) or user settings.
• Improved handling of connection URLs in comparison operations.
• The color of the Save button on the "Add migrations" page is now blue.
• Target databases will now be combined when specified in both project settings and user settings.
• It is now possible to opt out of creating a new folder when creating a new project.
• You can now highlight invalid field if the user tries to add a migration with special characters.
• Updated Electron to version 20.

Features

• It is now possible to edit the development and shadow database connections from the settings cog.
• The Flyway verb is now preserved when refreshing the Manage Migrations page.

Features

• It is now possible to run the Check command from the migrations screen.
• Updated Flyway to version 9.0.1.

Fixes

• The shadow database will now be cleaned automatically when a baseline script is deleted and regenerated.
• Fixed issue where incorrect target database name could be shown in Manage Migrations page.

Features

• It is now possible to directly select target databases when opening a project with targets configured.
• Small UI improvements to Target Databases configuration page.
• Commit is no longer disabled when a background fetch is in progress.
• Updated SQL Compare Engine to version 14.8.4.21440.
• Updated Schema Compare for Oracle Engine to version 6.0.9.516.

Fixes

• Passwords no longer need to be reentered when editing a connection.

Features

• It is now possible to manually add a migration script on the Migrations page.
• The version control page will now refresh if a git repository is initialized outside the toll.
• It is now possible to specify username and password in connection dialog for all databases.

Features

• It is now possible to trial Teams edition, though it is not yet available for purchase. It is possible to switch the edition being trialed from the "Compare editions" entry in the help menu.
• Improved error handling when attempting to view a migration that cannot be read from disk.

Fixes

• Fixed script viewer command menu containing some actions which could not be applied.
• Fixed dismiss button for the error notification being moved by long error titles.

Features

• Updated SQL Compare Engine to version 14.8.2.21316.
• Updated Schema Compare for Oracle Engine to version 6.0.8.484.

Features

• You can now edit database connections in the Migrations tab without first selecting them.

Fixes

• Fixed issue connecting using Azure Active Directory Interactive authentication from the database connection dialog.
• Fixed issue where the manage migrations table would overflow incorrectly given a large number of migrations.

Features

• Updated Flyway to version 8.5.13.
• Updated SQL Compare Engine to version 14.8.1.21246.
• Updated Schema Compare for Oracle Engine to version 6.0.8.465.

Fixes

• Fixed issue parsing comparison options.

Features

• For Oracle projects, it is now possible to specify schemas for the database to baseline against.
• For Oracle projects, an error will now be thrown when comparing with an unrecognized schema, instead of treating it as empty.
• For new projects, flyway.validateMigrationNaming is set to true by default, validating migration names when `flyway info` is run.

Fixes

• Fixed error when settings specified multiple times in flyway.conf.
• Fixed error when the same comparison option is specified multiple times.

Fixes

• Removed misleading message from connection dialogs for databases which only contain a JDBC URL field.
• Fixed error which could prevent the install update on exit button from starting the installer.
• Fixed error where manually checking for updates could fail when the automatic check was already running.

Features

• Improved error screen when unable to communicate with the Redgate licensing client.

Features

• It is now possible to persist and select target databases from the Manage Migrations page.
• It is now possible to configure a display name for the development database and for the shadow database.

Fixes

• Fixed an issue where it was possible to queue up multiple update installs.

Features

• The target database connection can now be edited on the Migrations page.
• For all database types, username and password can now be read from JDBC URL if pasted in.
• For Microsoft SQL Server, Oracle, and PostgreSQL, there will now be a prompt in the connection dialog for username and password if they are required but not supplied.
• For SQL Server Azure Active Directory interactive authentication, tenant IDs and client IDs can now be read from the JDBC URL if pasted in.
• For SQL Server Azure Active Directory interactive authentication, there will now be a prompt in the connection dialog for tenant ID and client ID if they are not supplied.
• For SQL Server the authentication and integratedSecurity parameters will now be correctly parsed from the JDBC URL if pasted in and will be visible in the connection dialog UI (they were previously added programmatically and not displayed).
• For Oracle, LDAP JDBC URLs will now be handled on the Migrations page.
• Updated Flyway to version 8.5.11.
• Updated SQL Compare Engine to version 14.7.7.21028.
• Updated Schema Compare for Oracle Engine to version 6.0.5.400.

Fixes

• Fixed a broken link to external documentation.
• Fixed an issue that caused parts of the UI to overflow out of the viewport.

Features

• It is now possible to configure undo script generation in the UI.

Fixes

• Fix for git stage operation failing when given a large number of files.

Features

• Improved signing in with your Redgate ID.
• Moved the 'Go to project folder' and 'Open in console' buttons to the tab menu to make closing a project easier.
• You can now configure schemas for your target connection in the Migrations page.

Fixes

• SQL Server connection dialogue now only highlights an empty database field on connection test.

Fixes

• Internal fixes and changes.

Features

• Added an error message when the installed version of git is unsupported (the minimum supported version is 2.30.0).

Fixes

• Fixed bug where an invalid oracle JDBC URL could not be edited using the connection dialog.

Features

• Clicking on migration entries on the Migrations page will now always show the versioned migration script by default.

Fixes

• Fixed an issue where certain log levels could cause licensing check failures.

Features

• The generate migrations page will now refresh automatically following a save to the schema model.
• Results screens will now be automatically dismissed when navigating away from tabs and performing related operations on other tabs.
• For SQL Server projects, the "Database name" field is now required in connection dialogues.

Fixes

• Fixed incorrect multi-selection behavior on the differences table when a filter is applied.
• Fixed an issue where Migrations operations could be called with stale parameters.

Features

• Made version of Flyway installed with Flyway Desktop accessible through the PATH environment variable.
• Flyway Desktop will now display a small splash screen before it's finished loading.
• The comparison option IgnoreSystemNamedConstraintNames is now overridable by the user, defaulting to false.

Features

• Breaking Change - The schema model page will now show for all Oracle projects - Oracle migrations are now always generated from the schema model and can no longer be generated directly from the development database.
• Breaking Change - Added Flyway parameters are no longer applied to the table on the Manage migrations page.

Fixes

• Fixed an issue where warnings or messages could be output in an incorrect format during comparison.
• Fixed an issue that prevented the dry run button from showing on the Manage migrations page.

Features

• Breaking Change - Flyway Desktop now encrypts Microsoft SQL Server connections by default when invoking Flyway.
• Objects being included in a baseline migration as dependencies are now declared to the user.
• Updated Flyway to version 8.5.3.

Fixes

• Generating baselines no longer include default objects as dependencies.
• Prevent the flyway_schema_history table from being shown as dropped when generating migrations in Oracle single schema mode.

Fixes

• Prevent the flyway_schema_history table from being shown as dropped when generating migrations in Oracle single schema mode.

Fixes

• Fixed an issue where some actions buttons on the generate migrations tab could be hidden off the page.

Features

• Added filter box to the Schema model and Generate migration pages.
• Long object or schema names will now truncate in the changes table. Hover for tooltip of full name.

Fixes

• Fixed an issue where exception reporting would happen when it should not.

Features

• Added the option to run different Flyway commands from the manage migrations page.
• A schema model folder is no longer created in a new project which does not support schema model behavior yet.
• Updated Flyway to version 8.5.2.
• Updated SQL Compare Engine to version 14.6.21.20756.
• Updated Schema Compare for Oracle Engine to version 6.0.2.74.

Fixes

• Fixed an issue with importing flyway.conf for some database types.
• Fixed an issue with error message "It is not possible to apply changes directly to your migrations" which might occur if applying after clicking between tabs quickly.
• Fixed issue where objects with no schema might be displayed with dbo as the schema.
• Fixed issue where dry run script modal would still be open following migrate action.
• The target database on the Manage migrations page is now cleared when the project closes.
• Fixed SQL Server issue where baseline script might fail to deploy to shadow database because of schemas or roles already existing.
• Fixed SQL Server issue where Flyway schema history table could not be created in the shadow database when configured in a custom schema.

Fixes

• Fixed error caused by object definitions over 150,000,000 characters long.

Fixes

• Fixed an error notification that could occur when closing a project during a comparison.
• Fixed an issue where comparing schema model could fail for certain log levels.

Features

• Comparisons now have richer progress reporting.
• Added more granular error handling and verbose logging around comparison artifact serialization.
• Current log level is now visible via a tick next to the selected log level in the help menu.
• Updated Flyway to version 8.5.1.
• Updated Schema Compare for Oracle Engine to version 6.0.0.49.
• Updated SQL Compare Engine to version 14.6.20.20651.

Fixes

• Fixed missing check for updates button on the help menu.

Features

• Updated SQL Compare Engine to version 14.6.19.20618.

Features

• Added a menu option to open the current project in the console.
• Added the option to clean the shadow database and rerun comparison following an error comparing migrations.

Fixes

• Pop-ups will no longer appear from actions made by unrelated tabs.
• Fixed issue that prevented changes to generated scripts from being saved.

Features

• Added additional logging around database connection resolution.
• Baseline scripts are now saved as flyway baseline scripts with a B prefix.
• New SQL Server projects will default to dbo for creating schema history tables.

Fixes

• The shadow database will be cleaned if any migrations contain a Failed status.
• Fixed possible getStatus errors which might appear in the logs.

Fixes

• Fixed issue where list of recent projects might not update correctly when empty.
• Fixed an issue where generated scripts would not be renamed correctly.

Features

• It is now possible to automatically generate undo scripts by setting generateUndoScripts to true in the Deployment section of the flyway-dev.json settings file.
• Unexpected flyway errors should now be reported with additional context.
• Dependencies included when saving schema changes to project or applying schema changes to the development database are now displayed on operation success.

Fixes

• The View Command window on the Migrations page now shows the database connection properties.
• Flyway migrate error messages are now correctly displayed.

Features

• Added the ability to view undo scripts from the Migrations page.
• Improved error handling when opening an invalid project.
• Improved error handling when failing to connect to a database when refreshing on the Schema model or Generate migrations pages.
• Database dropdown when creating a new project is now filterable.
• List of flyway parameters on the Migrations page is now filterable.
• The Generate migrations and Schema model pages are now more consistent in style.
• Updated Flyway to version 8.4.4.
• Updated SQL Compare Engine to version 14.6.17.20533.
• Updated Schema Compare for Oracle Engine to version 5.7.32.2711.

Fixes

• Fixed error when generating a migration and the migrations folder doesn't exist.
• Fixed issue updating instance name in SQL server connection dialog when instance name appended to host name.

Fixes

• Fixed issue where Flyway Desktop would keep prompting for an update.

Features

• Improved error reporting for errors interacting with the filesystem.
• Connection fields now default to highlight the text on selection (excluding the JDBC URL).
• Updated Flyway to version 8.4.2.
• Updated SQL Compare Engine to version 14.6.16.20465.

Fixes

• Fixed error when clicking on the baseline entry in the Migrations view.

Features

• Added Encrypt and TrustServerCertificate checkboxes to the connection dialogs for Microsoft SQL Server projects.
• Updated Schema Compare for Oracle Engine to version 5.7.32.2687.
• Updated SQL Compare Engine to version 14.6.16.20418.
• Tooltips have been added to version control buttons when disabled.

Fixes

• Addressed issue Devart.Data.Oracle.dll as there is a bug in version 5.15.1410.

Fixes

• Fixed an issue with the application icon not showing.

Features

• Added the ability to specify custom flyway options on the migrate page.
• Updated SQL Compare Engine to version 14.6.15.20400.
• Updated Flyway to version 8.4.1.
• Updated Schema Compare for Oracle Engine to version 5.7.30.2661.

Fixes

• Fixed an issue where generating a very large migration script might fail.
• Fixed an issue for Windows users where an error could be thrown when linking a database on the Migrate page.

Features

• Added new Migrations page where you can view migrations and test deployments against databases.
• Updated Schema Compare for Oracle Engine to version 5.7.29.2579.
• Updated SQL Compare Engine to version 14.6.14.20330.
• Removed preview label from Microsoft SQL Server.

Fixes

• Fixed link to apply functionality in successful pull message.