Liquibase, Flyway or a Visual Schema Compare: Which to Use in 2026 | DbSchema
Liquibase replays a changelog, Flyway a folder of numbered SQL files, and a visual schema compare diffs the design against the database. What each costs and catches.
Migrations
Every post tagged migrations on the DbSchema blog.
Letting an AI Coding Agent Near Your Production Database | DbSchema
What the Replit and PocketOS incidents show about AI coding agents and production data, and the roles, scripts and review step that stop the next one.
What a Database Migration Tool Does
A database migration tool turns schema changes into SQL that every environment runs once, in order. See a real PostgreSQL 16 migration fail and pass.
Comparing Production and Staging Schemas
Compare production and staging database schemas before a release. See which catalog queries catch which drift on PostgreSQL 16, and where DbSchema fits.
Comparing Two Database Schemas
How to compare two database schemas: a catalog query, a schema-only dump diff and a model compare that writes the migration SQL, tested on PostgreSQL 16.
Putting a Database Schema in Git
Database schema version control with Git: keep the schema as a text model file, review its diffs, merge branches and sync the change into the database.
Rolling Back a Database Schema Change
Can you roll back a database schema change? Which engines undo DDL in a transaction, what data is gone for good, and how to run the reverse script.
Finding Schema Drift Between Database Environments
Confirm schema drift between production and staging: pick a reference, compare it in DbSchema, decide each difference, and schedule the check.
Visual Schema Diff or a Code-Only Migration Library
Compare code-only migration libraries with visual schema diff tools. Learn how to version XML models in Git and generate migration scripts automatically.
Why Version a Schema at All
Learn why database schema versioning is essential for engineering managers to eliminate deployment bottlenecks and automate migration scripts safely.
Reviewing a Schema Change in a Pull Request
Learn how to review a database schema change in a pull request. Uncover the exact SQL statements and engine lock levels that a plain text diff hides.
Turning a Schema Diff Into a Safe Migration Script
How database administrators turn a schema diff into a migration script: version the XML design model in Git, generate the DDL, review it before it runs.
Schema Versioning Without a Migration Framework
Version your database schema without a migration framework. Save the design as an XML file in Git and generate SQL migration scripts automatically.
Open-Source Schema Migration Tools
Discover how open-source schema migration tools help backend developers manage database changes safely. Compare DbSchema, Liquibase, and Flyway.