Back to migration guides

database • 2.0.0 → 3.0.0

Database Schema v3 Migration

Migrate database schema to v3 with new workspace isolation, multi-tenancy columns, and audit logging.

Upgrade steps

1. Backup database

automated

Create a full backup before migration

pg_dump $DATABASE_URL > backup.sql

2. Run migrations

automated

Execute Prisma migrations for v3 schema

npx prisma migrate deploy

3. Verify data integrity

automated

Run verification scripts to ensure data consistency

npm run db:verify