Graph

Liquibase Pro Documentation

Liquibase Pro is a complete Database DevOps platform with security, compliance, and control.

Frequently Searched ARTICLES

Check out what everyone has been reading about

Documentation - User guide

What is a changelog?

With Liquibase, you use a text-based changelog file to sequentially list all changes made to your database. This ledger helps Liquibase audit your database and execute any changes that are not yet applied. You can store and version your changelog in any source control tool.

Documentation - User guide

What is a changeset?

A changeset is the basic unit of change in Liquibase. You store all your changesets in your Changelog. Your changesets contain Change Types that specify what each change does, like creating a new table or adding a column to an existing table.

Documentation - User guide

What are preconditions?

Preconditions are tags you add to your changelog or individual changesets to control the execution of an update based on the state of the database. Preconditions let you specify security and standardization requirements for your changesets. If a precondition on a changeset fails, Liquibase does not deploy that changeset.

Documentation - Get started

Get started with Liquibase

After you install Liquibase, get started with our tutorial and learn how Liquibase works.

Documentation - User guide

Introduction to Liquibase

Liquibase is a database schema change management solution that enables you to revise and release database changes faster and safer from development to production.

Documentation - Integration guide

What support does Liquibase have for Microsoft SQL Server?

Microsoft SQL Server (MSSQL) is a relational database management system. Microsoft SQL Server supports different editions and components that accommodate unique performance and depend on your specific requirements.

Documentation - User guide

What is the Liquibase properties file?

You can use a defaults file called liquibase.properties to store information that Liquibase needs to connect to a particular database, along with other properties that rarely change. This lets you avoid entering properties through your command line, saving you time and reducing errors.

Documentation - Reference guide

What are contexts?

Contexts are tags that control whether commands like update run certain changesets. You add contexts directly to changesets in your changelog and filter them at runtime using the --context-filter attribute in the CLI. You can specify a context name as any case-insensitive string. The context filter is a logical expression that you can use to specify one or more changeset contexts.

Frequently Asked Questions

If you want to create a schema that doesn't already exist, you can do this with Liquibase in two ways: using formatted SQL or an XML changelog with the SQL tag.

For detailed instructions on how to do this, visit our Creating a New Schema article in the Liquibase Knowlegebase.

Upgrade to Liquibase Pro 4.32

Upgrade to Liquibase Pro 4.32

Liquibase University

Advance your skills at your own pace

Learn Liquibase, level up your learning, and stand out as a subject matter expert with certifications and digital credentials. Free for all users!

Fundamentals of LB Nov _2024
Get Started

Fundamentals of Liquibase

For users who may be new to Liquibase or those who are interested in learning about the core functionality of the tool to track, manage, and deploy database changes. Learn about the most commonly used commands, Liquibase best practices, and a walkthrough of a typical developer workflow using Liquibase.

*Course certificate and digital credential issued upon completion.

Managing Changelogs Nov 2024
Progress your skills

Managing Liquibase Changelogs

For users who wish to learn how to apply different tactics and strategies to manage their Liquibase changelogs. Includes how to use labels, contexts, preconditions, and grooming and modifying changelogs. You will also learn how to organize, exclude, and archive changelogs.

*Course certificate and digital credential issued upon completion.

Polar LB204 Common Patterns Nov 2024
Progress your skills

Common Liquibase Design Patterns

This course is for users who wish to learn about different Liquibase design patterns. It includes structuring a new Liquibase project, addressing database drift, implementing database guardrails, and utilizing property substitution.

*Course certificate and digital credential issued upon completion.

authoring-liquibase-changesets
Developer-focused

Authoring Liquibase Changesets

Changesets are how database changes are authored in Liquibase. This course will help Liquibase users understand how to apply different options to specify those changes, including using database tags, comments, and authoring changesets using the sqlFile Change Type.

*Course certificate issued upon completion.