Introduction

The articles and videos in this space are meant to assist you in understanding the Liquibase Business product and planning the implementation of the product to bring consistency and visibility to the database development and release activities in your organization.

Step 1: Learn How Liquibase Business Works

How Liquibase Business Works

Step 2: Learn How to Download, Install & Configure Liquibase Business

Installation Walkthroughs for Common Client Configurations

Using the GUI Installer on Windows

Installing from the CLI on Linux

Take a Tour of the Install Process in Our Video Library

The Knowledge Base managed by Liquibase’s Customer Success team includes a video library with several practical examples of our products' implementation and use.

Check out our videos on product installation here: Video Library - Product Installation

Then Take a Deeper Dive Into Product Installation & Management

Installation Documentation Topics

Step 3: Learn How to Include the Deployment Monitoring Console In Your Liquibase Business Implementation

Liquibase Business includes the Deployment Monitoring Console (DMC). The DMC is a light weight web application that centralizes the deployment status of all of the environments managed by Liquibase Business so that interested parties can see where changes have been deployed or review deployment reports on demand. For more information consult the DMC Documentation.

To get started, check out the videos below.

Installing the Deployment Monitoring Console

Using the Deployment Monitoring Console

Advanced: Integrating the Deployment Monitoring Console with with LDAP/Active Directory

Step 4: Learn How to Create & Share Liquibase Business Projects

In this section, you will learn to create the Liquibase Business Projects and Pipelines that you will use to introduce and automate the propagation of Database Change.

Topic 4.1 - Creating & Share Liquibase Business Projects in Source Code Control

Topic 4.2 - ChangelogSync

You will usually be adding Liquibase Business to existing pipelines of databases, so you need a method to tell Liquibase Business when changes within the Changelog are already in a given database. This is accomplished via the ChangelogSync command via the GUI or CLI.

The changelogSync command is typically used when you want to baseline a new database environment. For example, you can use the changeLogSync command to mark a change as executed if the object associated with the change was created manually on the database. By marking the changeset as executed, it prevents the next Liquibase update from failing as it tries to create an object that already exists.

Here is a video that explains using ChangelogSync:

Step 5: Learn How to Onboard & Manage Database Changes with the Liquibase Business Changeset Wizard

Liquibase Business allows you to import, order, control and track the SQL scripts you use to make database updates. The Liquibase Business GUI includes a Changeset Wizard to streamline this process.

Start with a Video Overview of Adding a Script & Deploying it Through The Pipeline

The following video takes you through the process of adding a script to an SQL Server project and promoting it to downstream environments. Highlights of this video include an overview of Changeset settings used to control where and when a Changeset is executed; examples of Liquibase Deploy reports and logs; and an introduction to the Liquibase Business status capabilities.

IMPORTANT NOTE:

• For Oracle use “Execute with SQLPlus” in the “Oracle Utilities” section of the Changeset Wizard.

• For SQL Server use “Execute with SQLCMD” in the “Other” section of the Changeset Wizard.

• For Postgres use “Execute with psql” in the “Other” section of the Changeset Wizard.

• For DB2 use “Execute with CLPPlus” in the “Other” section of the Changeset Wizard.

Learn How Liquibase Supports Your Custom Rollback Scripts for Each Change

Learn How to Control Where Scripts are Deployed by Using Labels & Contexts

Learn More About Other Settings in the Change Set Wizard

Step 6: Learn How to Incorporate Liquibase Business Into Existing DevOps Toolchains

Liquibase Business provides a flexible, comprehensive command line interface for integrating Liquibase Business operations into any existing automated workflow.

CLI Reference

Additional Resources