Redgate Change Automation 4

Redgate Change Automation 2 release notes

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

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




Didn't find what you were looking for?