resolve
The prisma migrate resolve command allows you to solve migration history issues in production by marking a failed migration as already applied (supports baselining) or rolled back.
prisma migrate resolve [options]The datasource URL configuration is read from the Prisma config file (e.g., prisma.config.ts).
- Recover from failed migrations
- Baseline databases when starting to use Prisma Migrate on existing databases
- Reconcile hotfixes done manually on databases with your migration history
Run prisma migrate status to identify if you need to use resolve.
| Option | Description |
|---|---|
-h, --help |
Display help message |
--config |
Custom path to your Prisma config file |
--schema |
Custom path to your Prisma schema |
--applied |
Record a specific migration as applied |
--rolled-back |
Record a specific migration as rolled back |
You must specify either --applied or --rolled-back.
bunx prisma migrate resolve --applied 20201231000000_add_users_tablepnpm prisma migrate resolve --applied 20201231000000_add_users_tableyarn prisma migrate resolve --applied 20201231000000_add_users_tablenpx prisma migrate resolve --applied 20201231000000_add_users_tablebunx prisma migrate resolve --rolled-back 20201231000000_add_users_tablepnpm prisma migrate resolve --rolled-back 20201231000000_add_users_tableyarn prisma migrate resolve --rolled-back 20201231000000_add_users_tablenpx prisma migrate resolve --rolled-back 20201231000000_add_users_tablebunx prisma migrate resolve --rolled-back 20201231000000_add_users_table --schema=./schema.prismapnpm prisma migrate resolve --rolled-back 20201231000000_add_users_table --schema=./schema.prismayarn prisma migrate resolve --rolled-back 20201231000000_add_users_table --schema=./schema.prismanpx prisma migrate resolve --rolled-back 20201231000000_add_users_table --schema=./schema.prisma