Database Migrations in Git: Commit, Review, Run
Keep database migrations in Git: commit each one as a plain SQL file, then run it from that exact commit. Fetch, pull and push from Fox Schema.
Database Schema History: Snapshots, Revert, Applies
Database schema history in one place: track versions, see what changed, revert with a plan you review first, and review every migration run.
Rename a Column Safely, or Change Its Type
Rename a column safely or change its type in steps: see what it touches, copy rows in batches, then switch over. Preview every statement first.
Archive a Large Table with Fox Schema’s Clone Table
Archive a large table as name_N and recreate an empty one with the same name and columns, so your app keeps working. Preview the SQL first.
Multi-Tenant Schema Management: Keeping Per-Tenant Databases in Sync
How to detect and fix schema drift across per-tenant or shared-schema multi-tenant databases, and how to roll out migrations across many tenants safely.
Best Database Migration Tools: What Makes One Advanced
The criteria that separate the best database migration tools from basic ones: readable generated SQL, cross-dialect awareness, dry-run safety, and CI fit.
How to Find Which Indexes Are Actually Used
How to find unused database indexes with real usage stats in PostgreSQL, MySQL, SQL Server, Oracle, Db2, and SQLite, and why a zero-usage counter isn't reason enough to drop one.
Rollback Strategies for Database Schema Migrations
How to plan safe rollbacks for schema migrations: reversible vs irreversible changes, pre-migration snapshots, and testing the rollback itself.
Large-Table ALTER Strategies: Changing Schema Without Locking Production
How to add columns, change types, and backfill huge tables without long locks: native online DDL per dialect, expand/contract, batched backfills, and gh-ost.
Generated and Computed Columns Across Database Dialects
How PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, and SQLite differ on stored vs. virtual generated columns, and what breaks when you migrate them.
