Liquibase Database Schema Migration

Liquibase Database Schema Migration

liquibase.org

2

About this website

Liquibase is an open-source database schema change management tool that tracks, version-controls, and deploys database changes. Founded by Nathan Voxland in 2006 and now developed by Liquibase Inc. (headquartered in San Francisco, California), it is one of the most widely used database migration tools in enterprise environments. Key features: changelog-based migration: database changes are defined in changelog files (XML, YAML, JSON, or SQL) as an ordered list of changesets, each representing an atomic change. Changeset types: createTable, addColumn, dropColumn, renameColumn, createIndex, addForeignKeyConstraint, loadData, sql (raw SQL), and hundreds more predefined refactoring operations. Tracks applied changes via DATABASECHANGELOG table, ensuring each changeset runs exactly once across all environments. Rollback support: each changeset can define a rollback strategy (tag-based, count-based, or custom SQL). Diff tool: compares two databases and generates a changelog describing the differences. Snapshot: creates a baseline changelog from an existing database schema. Contexts: group changesets by deployment context (dev, test, prod). Labels: tag changesets for selective execution. Precondition checks: verify database state before applying a changeset. Database support: Oracle, MySQL, PostgreSQL, SQL Server, DB2, H2, SQLite, Snowflake, MongoDB, and 20+ databases. CLI, Maven plugin, Gradle plugin, Spring Boot integration, Docker. Version 4.25+ adds structured SQL and improved observability. Liquibase Pro adds drift detection, targeted rollbacks, and reports. Open source (Apache-2.0) and Pro editions.

Tags & Categories

Statistics

2
Views
0
Clicks
0
Like
0
Dislike

Comments

Log In to post a comment

No comments yet. Be the first!