2.30.9111 - June 25 2020

Changes

• Extended integrated Flyway license

2.29.9059 - June 22 2020

Changes

• Upgraded the Redgate Oracle Schema Comparison engine to v5.7.4.3169

• Upgraded Flyway to v6.4.4

2.28.8908 - June 11 2020

Changes

• Upgraded the Redgate Oracle Comparison engine to v5.7.4.3129

2.27.8725 - June 5 2020

Improvements

• Adds a comment to the driftCommitScript.sql generated when drift is detected explaining how to incorporate it into the project.

• Improved performance when working with database snapshots.

Changes

• Upgraded Redgate Oracle comparison engine to v5.7.4.3111

• Upgraded flyway to v6.4.3

2.26.8472 - May 28 2020

Improvements

• Improved performance and stability of rca build

Changes

• Upgrades Redgate Oracle schema comparison engine to v5.7.4.3068

2.25.8118 - May 14 2020

Changes

• Upgraded the Redgate Oracle Comparison engine to v5.7.4.3020
• Upgrade the Redgate SQL Comparison engine to v14.2.14.15827
• Upgrade Flyway to v6.4.2

Fixes

• A DatabaseInformation.xml file is no longer required when running release prepare with hybrid-mode projects.

2.24.7990 - May 12 2020

Changes

• Upgraded the Redgate SQL Server comparison engine to v14.2.14.15786
• Upgraded the Redgate comparison reports generator to v5.1.1.576

2.23.7885 - May 09 2020

Changes

• Upgraded the Redgate Oracle Comparison engine to v5.7.4.2983

• Upgraded Code Analysis for Oracle to v1.8.4400.0

2.22.7802 - May 06 2020

Changes

• Upgraded the Redgate Oracle Comparison engine to v5.7.4.2980

2.21.7764 - May 05 2020

Improvements

• You can now specify a code analysis settings file to use when running rca build.

2.20.7693 - May 3 2020

Changes

• Upgraded the Oracle comparison engine to v5.7.3.2974

2.19.7509 - April 28 2020

Changes

• Upgraded the Oracle comparison engine to v5.7.2.2927

2.18.7332 - April 22 2020

Changes

• Upgraded Flyway to v6.4.0

2.17.7296 - April 20 2020

New Features

You can now use Source Control for Oracle filter files to filter out database objects.

How to use:

To use filters with RCA you will have to first generate a filters file using Source Control for Oracle. See https://documentation.red-gate.com/soco5/using-source-control-for-oracle/using-filters.

Once you have a filters file:

• make sure you copy and paste the file to the root of your project (i.e. the same level as your .conf file).

• go to your .conf file and add redgate.filter=./<filters file>

Fixes

• Fixed an issue where using multiple schemas would cause an error.

2.16.7262 - April 20 2020

Redgate Change Automation is no longer a beta product.

New Features

You can now use Schema Compare for Oracle ignore rules to filter database objects.

How to use:

To use ignore rules with RCA you will have to first generate an ignore rules file using Schema Compare for Oracle. See https://documentation.red-gate.com/sco5/setting-up-the-comparison/using-ignore-rules.

Once you have an ignore rules file:

• make sure you copy and paste the file to the root of your project (i.e. the same level as your .conf file).
• go to your .conf file and add redgate.ignoreRules=./<ignore rules fileName>

2.15.7160 - April 16 2020

Changes

• BREAKING CHANGE: Renamed the optional environment variable for specifying the target User in `rca release perform` to `PRODUCTION_DATABASE_USER`

2.14.7032 - April 11 2020

Improvements

• Improved the validation check of the schema history table done during `rca release perform`

• Enabled `rca test` to accept utPLSQL options (e.g. `--path` to set specific test suites to execute)

Changes

• BREAKING CHANGE: Split `release-prepare` and `release-perform` into multi-level verbs: `release prepare` and `release perform`

• BREAKING CHANGE: Renamed the environment variable options for the command lines to use underscores between words (e.g. 'BuildDatabasePassword' is now 'BUILD_DATABASE_PASSWORD')

• Upgraded the Schema Compare for Oracle engine to v5.7.2.2892

• Upgraded Flyway to v6.3.3

• Upgraded Code Analysis for Oracle to v1.6.4375

• Renamed artifacts to be consistently camel-cased

• Changed the build metadata artifact 'buildDatabaseUrl.txt' to be json-formatted and renamed it to 'buildMetadata.json'

• Changed the build metadata artifact 'PreReleaseMigrationLogState.sql' to be json-formatted and renamed it to 'preReleaseMigrationLogState.json'

• Reorganised the build and release artifacts to move non-user-facing artifacts into a '.metadata' folder

2.13.6835 - April 6 2020

Improvements

• Improved the messaging on detection of drift to include instructions for fixing it.

Changes

• Upgraded the Oracle comparison engine to v5.7.2.2870.
• Removed the SQL Compare warnings tab from the changeReport.html generated by release-prepare.
• Removed the Script tab from the changeReport.html generated by release-prepare.
• Removed the `--suites (-s)` argument from rca test and always run all of the utPLSQL tests in the project schema.

Fixes

• Fixed an issue where the build artifact was not properly validated during `release-prepare`.

2.12.6633 - March 31 2020

Changes

• Upgrade Oracle Schema Comparison engine to v5.7.1.2841.

• Upgrade Flyway to v6.3.2.

Fixes

• Correctly ship all third-party licenses including the Oracle FUTC.

• A missing schema is now considered to be empty when performing a comparison.

2.11.6391 - March 23 2020

Improvements

• Added better validation for required command line parameters.

Changes

• Updated the Oracle Schema Compare Engine to v5.7.1.2812.

Fixes

• Fixed issue where projects with no project id (set by Redgate Change Control) could not be built.

• Fixed an issue where incorrect parameters were being passed to some internally-generated Flyway commands

2.11.6391 - March 13 2020

Improvements

• Deprecation warnings are now logged to the console.

• Added an optional `--output (-o)` parameter to rca release-perform to specify the location to save the drift detection report.

Changes

• Simplified the directory layout of the build and release artifacts.

• Moved build artifacts also reported as part of the release artifact into a 'BuildArtifact' sub directory.

• Renamed the `--ReleaseArtifact (-r)` parameter required by rca release-prepare to `--output (-o)`.

• Changed all command line parameters to be camel-case sensitive. For instance, `--Force (-f)` is now `--force (-f)`.

• Upgraded Redgate Oracle Schema Compare Engine to v5.7.1.2785

• Upgraded Flyway by Redgate to v6.0.3

Fixes

• Fixed an issue where the invalid object check in rca build was not using the correct database schemas.

• Ignore permission differences when generating migration scripts in hybrid mode.

2.9.5930 - March 5 2020

Improvements

• Added drift detection to the `release-perform` command line which will stop the deployment if drift is detected.
• Added a `--Force` option to the `release-perform` command line which enables deployment to continue in the event that drift was detected.

Changes

• Upgraded `redgate.oracle.schemacompare.engine` to `v5.7.1.2748`.

Fixes

• Fixed an issue where the `driftCommitScript.sql` drift correction script was incorrectly generated.

2.8.5754 - March 2 2020

Changes

• Label the Windows installer for Redgate Change Automation with the `Beta` tag.

Fixes

• Corrects an issue where not all the included assemblies were being signed.
• Fixed an issue where the command line help text for the `--User` option was incorrect.
• Fixed an issue where database snapshots were not working if the target database included a materialized view.

2.7.5656 - February 26 2020

Fixes

• Fixed an issue where rca test would display incorrect help text.
• Fixed an issue where the changes report would not be generated.
• The help and feedback URLs in the changes report now goes to the appropriate locations.
• The deployment script is now shown under the "Script" tab in the changes report.
• rca.exe is now properly signed with the Redgate signature.

2.6.5604 - February 21 2020

Improvements

• Improved console logging for RCA commands.
  • The default output is much less verbose.
  • Added new parameters for setting logging level.
  • RCA no longer writes to STDERR.

Changes

• Code Analysis for Oracle will now report issues as warnings by default.

Fixes

• Updated Flyway to v6.2.4

2.5.5403 - February 18 2020

Improvements

• RCA is now available via Dockerhub. More information can be found here: https://hub.docker.com/r/redgate/change-automation

Changes

• Minor text fixes.

Fixes

• Ensure all Redgate CLIs are appropriately signed.
• Updated Flyway to v6.2.3

2.5.5027- February 18 2020

Improvements

• Initial release of Redgate Change Automation