

0 / 2 embers
0 / 3000 xp
click for more info
Complete a lesson to start your streak
click for more info
Difficulty: 3
click for more info
Not enough gems
Cost: 6 gems
1: Creating a Table
incomplete
2: Create Table Practice
incomplete
3: Altering Tables
incomplete
4: Intro to Migrations
incomplete
5: Up Migration
incomplete
6: Down Migration
incomplete
7: Migration Review
incomplete
8: SQL Data Types
incomplete
9: Practice – Posts Table
incomplete
10: Practice – Posts Table Migration
incomplete
Back
ctrl+,
Next
ctrl+.
This lesson's interactive features are locked, please to keep using them
Let's look at a more realistic migration that reflects a common evolution.
The projects table is being renamed to initiatives to better reflect how teams plan and track long-term work.
We also want to record when each initiative officially launched.
Up migration:
ALTER TABLE projects
RENAME TO initiatives;
ALTER TABLE initiatives
ADD COLUMN launched_at TIMESTAMP;Down migration:
ALTER TABLE initiatives
DROP COLUMN launched_at;
ALTER TABLE initiatives
RENAME TO projects;This pair of migrations is reversible and safe. If something breaks, we can undo it.
In real-world projects, we don't run raw SQL migrations. We use tools that help:
Track which migrations have been applied.
Organize migrations in files.
Apply and roll back safely.
| Tool | Language | Notes |
|---|---|---|
| Goose | Go | Native Go tool |
| Flyway | Java, etc. | Simple file-based |
| Liquibase | Java | More config-heavy |
| Alembic | Python | For SQLAlchemy |
| Prisma Migrate | TypeScript | Works with Prisma ORM |
| Drizzle Kit | TypeScript | Works with Drizzle ORM |
This will vary according to the tool you use.
Write migration files.
001_add_columns_to_transactions.up.sql
001_add_columns_to_transactions.down.sql
Apply them using a CLI:
migrate upYour tool logs which migrations ran, and prevents duplicate migrations.
Migration files are committed like code. They travel with your project, so your teammates and CI systems always apply the same schema changes in the right order.