4.4 — Automate EF Core migrations in deployment

[davidortinau]

Description

Automate EF Core migrations in the deployment pipeline. Ensures database schema is always in sync with code without manual steps or data loss.

Dependencies

• Depends on 3.2 — Configure Azure Database for PostgreSQL #49 (PostgreSQL)
• Depends on 4.2 — Create GitHub Actions deployment workflow #57 (Deployment workflow)

Acceptance Criteria

• Migration scripts generated: dotnet ef migrations script --idempotent
• Migrations run before app starts (init container or migration bundle)
• Tested: schema updates work end-to-end without data loss
• Rollback tested (previous migration script works)
• All migrations are additive (no data deletion)
• Staging and production both have clean migration history

Technical Notes

• Option A: Migration bundle (embedded in app)
• Option B: Init container that runs migrations before app
• Use --idempotent to make migrations safe to rerun
• Verify migrations work on both staging and production

---

Phase: 4 | Size: M | Owner: Zoe (Lead)