Deliver database changes

Delivery is where an authored change meets your pipelines. Deploy and track changes, compare and synchronize databases, automate with flow files, and execute changes through CI/CD.

When a policy check blocks a change, respond to the governance failure, then correct and resubmit. Reports and structured logging capture the record of what ran, and native executors run the SQL where your platform requires them.

Every operation in this stage reports to the server. That record is what Monitor, Measure, and Improve read.

In this section

• Respond to governance failures

• Correct and resubmit the change

Deploy and track changes

Deploy with update, understand deployment status, and manage tracking tables.

• Track and append manual changes with snapshots and diff-changelog

• Using snapshot-reference in diff-changelog commands

• How do I trim my changelog?

• Tracking tables: What is the DATABASECHANGELOG table?

• Deploy your changes with update

• Understand deployment status

Compare and synchronize databases

Diff environments and generate changelogs from existing databases.

• Filter what is compared: How do I include and exclude database objects?

• Compare a single database's current state against a previous state

• Synchronize two environments using diff-changelog

• Diff multiple schemas in Liquibase

• Size JVM heap and RAM for diff-class commands

• What is stored logic?

Automate with flow files

Chain commands into repeatable flows.

• What is a Liquibase flow?

• What is a flow file?

• What are flow conditionals?

• Use shell commands in flow files

• Exit a flow file

• What is a flow variable?

Execute changes through CI/CD

Design the pipeline and wire GitHub Actions, Azure DevOps, or AWS task definitions.

• Design your deployment pipeline

• Set up the automation prerequisites

• Set up GitHub actions

• Set up Azure DevOps pipelines

• Use GitHub actions with Liquibase

• Create an AWS task definition to run Liquibase commands

Generate reports

Operation reports for updates, rollbacks, checks, and drift.

• How do I enable operation reports?

• Use drift reports in your CI/CD pipeline

• Report reference: What reports does Liquibase produce?

Capture change data with structured logging

Feed structured log data to your observability stack.

• Assess logs to understand changelog efficiency

• Enable structured logging

• Analyze and use structured log data

• Disable structured logging

• What is structured logging?

• What are structured logging keys?

Use native executors

Run SQL through psql, SQLcmd, or SQL Plus where required.

• What are native executors?

• Configure changesets to use native executors

• What are the benefits of using native executors?

• Best practices when using native executors