Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Datical Liquibase Enterprise is a tool for implementing DevOps for databases. 

...

When you transition to using DaticalLiquibase Enterprise, the database changes move to a model where they are reviewed, packaged, and deployed automatically through the pipeline in parallel with application code changes.

  1. Create a Datical Liquibase Enterprise project to define the workflow for database changes - the stages of the workflow parallel application code stages.
  2. Check database changes into Source Control Management (SCM) alongside application code. 
  3. Datical Liquibase Enterprise tools package the SQL code into changesets and deploy the changes through the workflow 

...

First, configure a repository for the Datical Liquibase Enterprise project.  Second, configure a repository for database code. It can be in the existing developer repository, or a new sql script repository exclusively used for database changes.

  • Datical Liquibase Enterprise projects
  • SQL code changes for a project

Configure 3rd party CI automation triggers or polling to start packaging operations automatically.

...

Liquibase Enterprise Project: Defines the Databases for Each Stage and Deployment Order

A datical Liquibase Enterprise project (also called a deployment plan) defines the workflow for database changes.

...

Labels are user-defined text strings created during packaging or later in the deployment process. They are used to group related database changes, selectively deploy groups of changes, track deployed changes, and manage deployment workflow. Labels are automatically applied during packaging, specified by a developer at code check-in time and can also be specified by the DevOps engineer when configuring DaticalLiquibase Enterprise. The standard labels most often used in a project are the script name, pipeline, and ticket number labels.

...

Use automation software (build and release tools) to call Datical Liquibase Enterprise to perform these operations on database changes automatically. If you don't have automation in place yet, these operations can also be performed manually using the Datical Liquibase Enterprise CLI and/or Datical Liquibase Enterprise GUI.

Package SQL Code into Changesets

...

  • At multiple stages in the pipeline (starting with packaging), Datical Liquibase Enterprise checks the changes against rules that you configure. The rules reflect your DB administration practices and guidelines. 

...

  • A changelog is used to assess each stage in the process. It represents all changes that have been packaged.
  • Status shows whether all known changes have been deployed as well as what changes have or have not been deployed. 

Overview of

...

Liquibase Enterprise System Architecture

...

Liquibase Enterprise Solution Components & Interactions


Integrating

...

Liquibase Enterprise into CI/CD Toolchains