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.
   
   

   Open

   

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
   
   

   Open

   

3. Click Save and proceed to trigger the pipeline.

Pipeline Logs

Open