A bad database migration can take down production and lose data. These database migration best practices keep schema changes safe and reversible.
1. Database migration best practices start with reviewing the DDL
Never apply a generated migration blind. Read the DDL — it should target your database's exact dialect. Look for destructive operations (dropping columns, tables) and confirm they are intentional. A good tool shows you the script before anything is applied.
2. Snapshot before applying
Take a pre-migration snapshot so you can roll back if something goes wrong. FoxSchema does this automatically before it applies a migration, and records every run in history.
3. Never write to the source of truth by accident
When comparing two databases, make sure your tool only writes to the intended target. FoxSchema never modifies the source — it only writes to the target, and only when you explicitly apply.
4. Use skip-on-error for large migrations
For migrations touching many objects, an all-or-nothing rollback can be painful. A skip-on-error mode continues past any single object that fails and reports what was skipped, so you apply what works and fix the rest deliberately.
5. Verify afterward: a database migration best practice
Re-run a schema comparison after applying. A clean diff confirms the migration did exactly what you intended — no more, no less.
Database migration best practices for release day
On release day, keep the plan boring. Run the migration in a maintenance window or behind a feature flag, watch locks and replication lag while it runs, and keep the previous schema snapshot at hand so you can compare the result afterwards. Good database migration best practices also include agreeing a rollback owner before you start, so someone is clearly responsible for the decision if the run fails halfway, and writing down what you saw so the next release starts from experience.
6. Keep credentials encrypted
Database passwords should be encrypted at rest and never exposed to the browser. Treat the tooling around your migrations with the same care as the migrations themselves.
FoxSchema builds these practices in by default. Download it or read the docs.
Further reading: for more on database migration best practices, see the schema migration overview and the PostgreSQL ALTER TABLE guide.
