Automated Database Migrations with CFMigrations

By Eric Peterson

Elevator Pitch

Come learn about migrations, files that allow you to incrementally apply database changes. Store migrations with your code for an automated way to set up a development environment. Utilize CommandBox to run those migrations from the command line. Profit from the clarity and ease of your deployments.

Description

cfmigrations is a tool to describe database changes and version them with your application code. Using migrations you can:

  1. Write grammar-agnostic database schema changes with a fluent syntax using qb
  2. Apply your database changes in a programmatic, reproducible manner
  3. Save your migrations in source control
  4. Run your migrations from the CLI using CommandBox.
  5. Automatically migrate your database from CI servers
  6. Use migrations with TestBox to ensure a clean database environment every time

cfmigrations can be used in new projects, existing projects, or even just for testing. Come see how cfmigrations can help you tame your database.

Notes

While anyone can watch the presentation, to use cfmigrations a user will need either CommandBox or a CFML Server running Lucee 4.5+ or ACF 11+.

I’m the best person to talk about this subject because I am the creator of the module and have used it in over a dozen client projects in the various ways described in the description.