Liquibase is an open-source database schema change management solution which enables you to manage revisions of your database changes easily. Liquibase makes it easy for anyone involved in the application release process to:

• Eliminate errors and delays when releasing databases.

• Deploy and roll back changes for specific versions without needing to know what has already been deployed.

• Deploy database and application changes together so they always stay in sync.

Liquibase Tool Registry Configuration

1. In Liquibase tool, navigate to Connection tab and provide the proper credential values:

• Database Type - Select Oracle or Snowflake from drop-down.

• Database URL

• Port

• Username

• Password

• Service

Open

2. Save tool configurations and proceed to configure the tool in Opsera pipeline step.

Liquibase Pipeline Configuration

Workflow:

1. Liquibase View Pending Migrations Pipeline Step → Liquibase Deploy Pending Migrations

Open

Liquibase View Pending Migrations Pipeline Step Configuration

1. In pipeline workflow, add a new pipeline step with using Liquibase Tool.

2. Provide the following selections:
   
   Step Type - Select View Pending Migrations.
   Liquibase Database - Choose Liquibase Oracle or Liquibase Snowflake.
   SCM Type
   Select Account
   Repository
   Branch
   Changelog File - Path to the changelog file.
   Liquibase Schema - The schema to have the liquibase changelog table.
   
   

3. Click Save and proceed to the next pipeline step.

Liquibase Deploy Pending Migrations Pipeline Step Configuration

1. In pipeline workflow, add a new pipeline step with using Liquibase Tool.

2. Provide the following selections:

   Step Type - Select Deploy Pending Migrations.
   Liquibase Database - Choose Liquibase Oracle or Liquibase Snowflake.
   SCM Type -
   Select Account
   Repository
   Branch
   Changelog File
   Liquibase Schema
   
   

3. Click Save and proceed to trigger the pipeline.

Pipeline Logs