Liquibase Enterprise was formerly known as Datical DB.
Liquibase Enterprise Supported Databases
- Amber Williams
Database Requirements
The following databases are supported.
Database | Versions | Notes |
|---|---|---|
IBM DB2 | ||
IBM DB2 LUW |
| Support for 11.5 was added in release 7.12 |
DB2 z/OS |
| Support for 12.1.5 was added in the 8.2 release |
Microsoft SQL Server | ||
Microsoft SQL Server |
| JDBC driver supports TLS 1.0, 1.1, and 1.2 (Support for 2017 & 2019 was added in 7.9 release) (Support for 2012 was dropped in 8.5 release) (Support for 2022 was added in 8.5 release) |
Azure SQL Database | Latest Compatibility Level | As of the 7.9 Release |
Azure SQL Managed Instance | Latest Compatibility Level | As of the 7.10 Release |
Oracle | ||
Oracle |
|
|
Oracle on Amazon RDS |
| Oracle on Amazon RDS has some different behaviors than on-prem Oracle. The permissions required for the Datical user are slightly different and the backup configuration is different. |
Postgres | ||
EDB Postgres Advanced Server |
| Support for 13 was added in the 8.2 release Support for 14 and 15 was added in the 8.5 release |
PostgreSQL Community |
| Support for 12 & 13 was added in the 7.15 release Support for 15 was added in the 8.5 release |
PostgreSQL on Amazon RDS |
| Support for 12 & 13 was added in the 7.17 release Support for 14 was added in the 8.2 release Support for 15 was added in the 8.5 release |
PostgreSQL on Amazon Aurora |
| Support for 12 & 13 was added in 7.17 release Support for 14 and 15 was added in the 8.5 release |
PostgreSQL on Azure Database |
| Support for 11 was added in the 8.2 release |
Database Setup
For a general overview of the schema or databases required for a release pipeline, see Overview of Databases Used by Liquibase Enterprise.
You typically need to create the following objects:
REF database - Serves as the first step in any release pipeline. It is the CI deployment target when Datical DB packages SQL scripts and refactors them into changesets.
Tracking database or schema - Tracks the changes deployed to each database in the pipeline. A tracking database or schema is needed for each database in the release pipeline.
DMC Database - Records operations for Datical DB release pipelines. DMC (Deployment Monitoring Console) provides you a centralized location to view status and reports across Datical projects.
For instructions on setting up Datical DB to work with your database, see the section for your database type in Configuring Databases for Liquibase Enterprise Release Pipelines.
You typically need to do the following tasks:
Install a database client.
Create a DATICAL USER and DATICAL PACKAGING. Give them the required permissions. Datical DB operates as those users to deploy changes to the databases in the release pipeline.
Copyright © Liquibase 2012-2022 - Proprietary and Confidential