Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Go to https://download.liquibase.com/ to download files.

Notable Improvements

Tip

Update of Oracle Instant Client and SQLPlus

Customers using Oracle should note that the Oracle Instant Client packaged with Liquibase Enterprise has been updated from 12c to 19c in Release 8.6. Customers using a SQLPlus native executor hosted outside the Liquibase Enterprise installation should consider updating their client to a 19c version as new versions of Oracle may not be compatible with the 12c client.

Associated Tickets: DAT-16005

Info

Oracle 12 and 18 are deprecated as of Liquibase Enterprise 8.6 and are no longer supported databases. Please consider updating to Oracle 19c or 21c.

Tip

Version 0 Rollback Support for PostgreSQL Stored Logic Scripts

Liquibase Enterprise now supports rollback for Version 0 of PostgreSQL stored logic scripts. This means that Liquibase will track the initial content of the Postgres SQL stored logic scripts so that the rollback can either return the object to its initial state.

Associated Tickets:

Associated Documentation:

Enhancements

Tip

Ephemeral Packaging for Oracle Databases

For Oracle databases, two new package methods have been introduced to allow teams to create a temporary, or ephemeral, Ref DB for packaging changes. The functionality uses Oracle’s multi-tenant technology and requires that the first database in the pipeline be a pluggable database (PDB). A clone or copy is created of this database is created during the packaging operation. Scripts eligible for packaging are applied to the copied database and the database copy is destroyed at the end of the packaging operation. There are options to create the ephemeral database in the same CDB container as the first database in the pipeline (using the BackupRestoreOracleEphemeralInternalPdb packageMethod) or to create the copy in a second, or external CDB container (using the BackupRestoreOracleEphemeralExternalPdb packageMethod.)

Associated Tickets: DAT-13287

Associated Documentation: Configure Deployment Packager to Use an Oracle Ephemeral Database

Tip

Labels Filter added to Reports in DMC

A new column for Labels and an accompanying filter has have been added to the DMC under the Reports section. This The label column allows users to search reports by script name and or any release or other labels being used on by the pipeline, such as release or ticket number.

Associated Tickets: DAT-16057

Expand
titleNew filter for Labels in Reports section
image-20240228-150018.png

Notable Improvements

Tip

Update of Oracle Instant Client and SQLPlus

Customers using Oracle should note that the Oracle Instant Client packaged with Liquibase Enterprise has been updated from 12c to 19c in Release 8.6. Customers using a SQLPlus native executor hosted outside the Liquibase Enterprise installation should consider updating their client to a 19c version as new versions of Oracle may not be compatible with the 12c client.

Associated Tickets: DAT-16005

Tip

Version 0 Rollback Support for PostgreSQL Stored Logic Scripts

Liquibase Enterprise now supports rollback to Version 0 of PostgreSQL stored logic scripts. Liquibase now tracks the initial content, or Version 0, of a PostgresSQL stored logic script prior to any modifications. This allows the Liquibase rollback to automatically return the object to its initial state or drop any newly created objects.

Note this change only applies to PostgresSQL as Version 0 support already existed for Oracle, SQLServer, and DB2 databases.

Associated Tickets: DAT-16594

Associated Documentation: PostgreSQL Server Database Objects and Packaging

Database Support

Info

Oracle 12 and 18 are deprecated as of Liquibase Enterprise 8.6 and are no longer supported databases. Please consider updating to Oracle 19c or 21c.

Desktop Client and CLI Updates and Issues Addressed

...

Issue ID

Description

DAT-15913

Added Breadcrumbs and Back to … links on the Reports section to return to Project and/or Pipeline from the Reports page. Also added Pipeline Name column and accompanying filter to this page.

DAT-16057

Added labels column and accompanying filter to the Reports section of DMC.

DAT-16723

Added link to the Status screen of the DMC to directs users to the corresponding Report so that SQL and other content from the changeset is readily available.

Documentation for v8.6

Documentation is available in the following locations:

...