Redgate Change Automation 3

Redgate Change Automation 3 release notes

3.51.16878 - July 06 2021

Library updates

  • Updated SQL Compare Engine to 14.5.16.19386

3.50.16680 - June 25 2021

Library updates

  • Updated SQL Compare Engine to 14.5.14.19336

3.48.16192 - June 10 2021

Library updates

  • Updated SQL Compare Engine to 14.5.12.19214

3.47.16004 - June 04 2021

Library updates

  • Updated SQL Compare Engine to 14.5.11.19211

3.46.15709 - May 25 2021

Library updates

  • Updated SQL Compare Engine to 14.5.10.19140

3.45.15543 - May 19 2021

Library updates

  • Updated SQL Compare Engine to 14.5.8.19086

3.44.15405 - May 07 2021

Library updates

  • Updated SQL Compare Engine to 14.5.7.19007
  • Updated Code Analysis for Oracle - fixes issue caused by error parsing '+'

3.43.15113 - April 30 2021

Library updates

  • Updated SQL Compare Engine to 14.5.6.18928

3.42.14888 - April 19 2021

Improvements

  • No user facing changes in this release

3.41.14884 - April 19 2021

Fixes

  • Improved error messages when failing to validate flyway.locations property
  • flyway.conf files referenced in the settings which don't exist are now logged

3.40.14765 - April 12 2021

Improvements

  • Internal library updates and improvements

3.39.14713 - April 08 2021

Improvements

  • Update dependency redgate.oracle.schemacompare.engine to v5.7.14.1012
  • Update dependency org.flywaydb.enterprise:flyway-core to v7.7.2

3.38.14590 - March 30 2021

New Features

  • Added preview of SQL Server schema model functionality

3.37.14494 - March 23 2021

Changes

  • RCA command lines now take a project folder for the --project parameter (the .conf file path is still supported for now).
  • Updated dotnet version to 5.0.4.
  • Updated redgate.oracle.schemacompare.engine to v5.7.14.992.
  • Updated redgate.sqlcompare.engine to v14.5.2.18617.
  • Updated org.flywaydb.enterprise:flyway-core to v7.7.0.

3.36.14160 - March 09 2021

Improvements

  • update dependency org.flywaydb.enterprise:flyway-core to v7.5.4

Fixes

  • Fix build behaviour when output zip is provided without a path

3.35.13942 - February 18 2021

Fixes

  • RCA build now correctly copies filter and ignore files into build artifacts.

3.34.13884 - February 12 2021

Fixes

  • Resolved issue where comparison report wasn't running due to a failed resource lookup.

3.33.13625 - January 27 2021

Changes

  • update dependency redgate.oracle.schemacompare.engine to v5.7.12.897

3.32.13505 - January 19 2021

Improvements

  • update dependency redgate.sqlcompare.engine to v14.4.19.17949
  • update dependency redgate.sqldatacompare.engine to v14.4.18.17921

Changes

  • Config file names without directory info will be treated as inside current working directory

3.31.13408 - January 14 2021

Improvements

  • update dependency redgate.oracle.schemacompare.engine to v5.7.12.877
  • update dependency org.flywaydb.enterprise:flyway-core to v7.5.0

3.30.13291 - January 6 2021

Improvements 

  • update dependency org.flywaydb.enterprise:flyway-core to v7.4.0

3.29.13232 - January 4 2021

Improvements

  • update dependency org.flywaydb.enterprise:flyway-core to v7.3.2

3.28.13094 - December 18 2020

Improvements

  • Upgrade RedGate.Oracle.SchemaCompare.Engine to version 5.7.12.747

3.27.13019 - December 11 2020

Improvements

  • Update to Code Analysis for Oracle 1.13.4855

  • Update dependency redgate.oracle.schemacompare.engine to v5.7.11.675

3.26.12956 - December 08 2020

Improvements

  • update dependency org.flywaydb.enterprise:flyway-core to v7.3.1

3.25.12863 - December 03 2020

Improvements

  • Update dependency org.flywaydb.enterprise:flyway-core to v7.3.0

3.24.12759 - November 18 2020

Changes

  • Return to a fresh comparison after baselining on the save scripts screen

3.23.12559 - November 12 2020

Changes

  • Change init options to accept dev url and scripts folder path

Fixes

  • Fixed miscalculated version numbers for migrations immediately after baselines

3.22.12450 - November 10 2020

Changes

  • Remove the migrations location selector box from the wizard
  • Make --migrationsLocation param for rcc init optional
  • Display where the project file will be saved in new project wizard

Fixes

  • show correct error message when testing connection

3.21.12110 - November 02 2020

Improvements

  • Users are now prompted for JDBC URLs if any are missing from the project.
  • Improvements to error messages when certain required fields are missing.

Changes

  • Updated Flyway to v7.1.1.
  • Upgraded Redgate Oracle Schema Compare engine to v5.7.10.471.

Fixes

  • Fixed a bug where an error message may not have appeared on the apply to database tab.

3.20.11930 - October 22 2020

New Features

  • Added repair verb to the cli for repairing the development database schema history table.

  • Added version verb to the cli for getting the current software version of Redgate Change Control and the Flyway engine.

  • Added reset verb to the cli to enable management of the shadow scripts folder (an experimental feature).

Changes

  • Upgraded Redgate Oracle Schema Comparison engine to v5.7.10.444.

Fixes

  • Fixed a bug where project paths containing spaces were causing errors to be thrown.

3.19.11779 - October 19 2020

New Features

  • Added new rcc status command to the command line which throws an exception if there is a validation error.

Changes

  • Added the next suggested migration script version number to the response from rcc generate

  • Upgraded Redgate Oracle Schema Compare engine to v5.7.9.405

  • Upgraded Flyway to v7.0.4

Fixes

  • Fixed bug where an invalid value null was being passed to schemaVersion when attempting to generate migrations.

  • Fixed bug where project validation was incorrectly ignoring future migrations

3.18.11528 - October 09 2020

New Features

  • Initialize the shadow scripts folder when running rcc init in compatible projects.

Changes

  • Upgraded Redgate Schema Compare for Oracle engine to v5.7.9.390

Fixes

  • Fixed an issue where migrating the shadow database would fail if there was a validation error.

3.17.11469 - October 07 2020

Improvements

  • Remove empty repeatable migration scripts instead of adding a comment.

Changes

  • Upgraded Flyway to v7.0.1
  • Upgraded Redgate Schema Compare for Oracle engine to v5.7.9.374
  • BREAKING CHANGE - Replaced the --requestJson option for the rcc init command line verb with individual options.
  • BREAKING CHANGE - Replaced the --requestJson option for the rcc update command line verb with individual options.
  • Added shorthands to RCC command line verbs

3.16.11254 - October 01 2020

New Features

  • Provides the RCC CLI as a docker image.

Improvements

  • Improved logging when using the RCC CLI.

Changes

  • Added optional `--format` option to the RCC CLI verbs. Pass "json" to get machine-readble output.
  • Upgraded the Redgate Oracle Schema Comparison engine to v5.7.9.297

Fixes

  • Fixed an issue where objects being dropped were first being checked for existence.

3.15.11152 - September 25 2020

New Features

  • Added RCC CLI to environment PATH.

Changes

  • Upgraded Flyway to v6.5.7
  • It is now possible to read configuration options from a .conf.user file if present in the project.

Fixes

  • Fixed an issue where versioned migrations with large numbers in the filename could fail to parse.

3.14.11088 - September 22 2020

Changes

  • Upgraded Flyway to v6.5.6
  • Redgate Change Control now always uses the inbuilt flyway license key instead of reading it from the config file.

3.13.10951 - September 14 2020

Fixes

  • Fixed an issue preventing the Programmable Object details from being expanded on the save scripts page.

3.12.10833 - September 04 2020

Improvements

  • Added timestamps to the auto-generated version number of new migration scripts.

Changes

  • Changed the way messages are displayed to the user within the app.

  • Upgraded the Redgate Oracle Comparison engine to v5.7.8.

Fixes

  • Fixed an issue where generating a baseline script failed with the error 'filename or extension is too long'.

3.11.10748 - September 02 2020

Fixes

  • Fixed an issue where the shadow database could not be updated with scripts containing SQL*Plus syntax.

  • Fixed an issue where logs were not being correctly handled when applying scripts to the database.

  • Fixed an issue where applying scripts failed but was reported as a success.

  • Fixed an issue where unstaged files were not being staged before committing.

3.10.10695 - August 28 2020

Improvements

  • When pulling changes, the message to apply changes to database is now shown as an info message and it's only displayed if you have any pending migrations after the pull.
  • Clicking on the apply to database link from the version control tab (after pulling changes) will now also refresh the Apply to database page.
  • A link to more help has been added to the repair modal.
  • A comparison option file generated by Source Control for Oracle can now be used in non-hybrid projects (i.e. projects that use a database as the development source) by including the ComparisonOptions.xml file in the same directory as the .conf file.

Changes

  • When only repeatable migrations have been generated the first accordion is expanded by default.

Fixes

  • Fixed an issue where applying pending migration would fail if database credentials were stored in the conf file.

3.9.10574 - August 25 2020

Improvements

  • Show the number of pending migrations on the apply to database page.

  • Improve performance of the New Project Wizard by no longer testing the same connection details multiple times.

  • Improve clean up of temporary files.

Changes

  • Upgraded Flyway to v6.5.5.

  • Clarified the wording of the title of the baseline modal.

  • Enable flyway.outOfOrder by default in new projects.

  • Update default comparison options to stop excluding SET DEFINE OFF.

Fixes

  • Fixed an issue where attempting to commit files staged for deletion would fail.

  • Fixed an issue where fetching branches in a repo with no remote would fail.

  • Fixed an issue where applying scripts to the database could fail if SQL*Plus specific syntax was used in the script.

3.8.10312 - August 14 2020

Improvements

  • Refreshes the current branch details after pushing commits.

  • Improves error messaging if pushing commits fails.

  • Trims whitespace from new branch names before attempting to create the branch.

  • Automatically focuses to the input field when loading the create new branch modal.

Changes

  • Pulling changes from git now behaves according to the user-defined global git settings.

  • Upgraded flyway to v6.5.4.

Fixes

  • Fixed an issue where a versioned script would be created with only a SET DEFINE OFF statement.

  • Fixed an issue where a versioned script would be created with only a script header comment.

3.7.10074 - August 05 2020

Fixes

  • Fixed an issue that could cause project load errors when using the redgate.experimental.shadowSchema project option when credentials were not present in the project file.

3.6.10070 - August 04 2020

Changes

  • Upgraded flyway to v6.5.3

Fixes

  • Fixed an issue that could cause "null password given" errors when using a SOCO dev source.

3.4.9958 - July 27 2020

Improvements

  • The current Flyway version is now shown in the RCC logs and about dialog.

Changes

  • Upgraded Flyway to v6.5.2
  • Downgraded Devart dotConnect for Oracle to v9.11.980 to work around a "Value cannot be null (Parameter 'hostname')" error

3.3.9794 - July 16 2020

Improvements

  • Made the last updated time on the generate migrations tab more user-friendly.

Changes

  • Upgraded Flyway to v6.5.1.

Fixes

  • Fixed issue where hybrid projects were not using the default comparison options from Source Control for Oracle if no ComparisonOptions.xml exists.

3.2.9527 - July 07 2020

Improvements

  • Automatically detect and apply comparison options set in the linked Source Control for Oracle project when using hybrid mode.

Changes

  • Automatically clear the commit message after successfully committing changes.

  • Upgrade Flyway to v6.5.0.

  • Reduced the amount of logging with the default setting.

Fixes

  • Fixed an issue where Redgate Change Control would crash if switching between projects with no migrations present.

3.1.9415 - July 02 2020

Fixes

  • Fixed an issue where RCC would fail to connect to the shadow database

3.0.9366 - June 30 2020

New Features

The version control page is no longer an experimental feature and can now be used without setting up an environment variable.

Improvements

  • A warning message is now shown when pulling changes causes a merge conflict, any further actions are disabled until the conflicts have been resolved

Changes

  • The commit table now only lists files that are within the project directory (the directory containing the .conf file) or any of its subdirectories

Fixes

  • The flyway schema history table and permissions are now properly excluded from the shadow scripts folder

  • Fixed an issue where the number of pulled changes were not being reported correctly

  • Fixed an issue where the selection state in the commit table would reset after refocusing the window


Didn't find what you were looking for?