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.
Migrations
Every post tagged migrations on the DbSchema blog.
What a Database Migration Tool Does
Learn how a database migration tool tracks schema changes and generates safe SQL scripts. We compare Flyway, Liquibase, and visual synchronization tools.
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.
Comparing Production and Staging Schemas
Learn how to compare production and staging database schemas, identify hidden schema drift, and use DbSchema to generate precise visual migration scripts.
Comparing Two Database Schemas
How to compare two database schemas and generate safe DDL migration scripts, with DbSchema Pro, Microsoft SSDT and Redgate SQL Compare for SQL Server.
Putting a Database Schema in Git
Put your database schema in Git: state-based vs migration workflows, Git best practices, and automated migration scripts from a plain-XML model.
Liquibase, Flyway or a Visual Schema Compare
Compare Liquibase and Flyway for database DevOps, and discover how a visual schema compare uses Git-versioned XML files to generate migration scripts.
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.
Finding Schema Drift Between Database Environments
Learn what database schema drift is, why it breaks data engineering pipelines, and how to detect and synchronize schema changes across environments.
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.
Rolling Back a Database Schema Change
When a database schema change goes wrong, decide quickly if it can be reversed. Learn how PostgreSQL, SQL Server, and MySQL handle DDL rollbacks.