Versions Compared

Key

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

...

Note: Microsoft’s Azure SQL Managed Instance will be supported in a future release.

Note

SQL Server 2008 is No Longer Supported

To support Azure SQL Database, the SQL Server JDBC driver provided on our update site and in the composite repository was updated to version 8.4.1. This version of the JDBC driver does not support any variant of SQL Server 2008. Microsoft ended extended support for SQL Server 2008 on July 9, 2019.

Configurable Pattern Matching for Label Assignment in Source Code Control Commit Messages

...

The NLS_LANG environment variable is used by SQL*Plus & Oracle databases to ensure that script contents are correctly interpreted during execution and that data values are stored appropriately in the database. The NLS_LANG environment variable can now be set on a project by project basis so that users no longer have to set those environment variables outside of their Liquibase Enterprise operations. For more information on setting this project property see Writing SQL Scripts for Datical DB

New Change Set Wizard Options for Business & Enterprise Users

We have moved the options for adding SQL scripts to the Changelog to the top of the list of Change Set Wizard options for easier access. We have also added three options for SQL Scripts in the Change Set Wizard.

Option Name

When to Use It

Execute a DML Script with sqlplus for Oracle Databases

This option indicates that the script added to the changelog should be considered for the Oracle DML Forecast feature. The DML Forecast feature will execute the script using sqlpluswithout committing the changes made by it. This can be used prior to deployment of the script to understand the scripts impact. This feature only applies to the Forecast operation for Oracle Databases.

Execute with edbplus for EnterpriseDB Databases

This option should be used to execute SQL scripts with the edbplus client against EnterpriseDB databases

Execute a SQL script file using JDBC

This was formerly the “Custom SQL (External File)” option in the Changeset Wizard. This option indicates that the script should be executed using a JDBC connection instead of an external client like sqlplus or sqlcmd. It’s been renamed to better communicate its purpose.

Recent Notable Changes

(Enterprise & Business 7.6) DATA_DML Package Method Creates Changesets With Oracle SQL Parser Disabled by Default

...