Can prisma generate rollback sql Prisma migrate dev reset al Prisma #orm-help

Can prisma generate rollback sql? Prisma migrate d...

Takeo Kusama

06/28/2022, 9:58 AM

Can prisma generate rollback sql? Prisma migrate dev reset all migration if having conflict migration sql which not existed when finally run migration. If we fails migration for dev and want to re-migrate without dropping table data, currently possible solution is to run manually sql?

✅ 1

Irek Prucnal

06/28/2022, 10:03 AM

I guess this is what you may be looking for: https://www.prisma.io/docs/guides/database/developing-with-prisma-migrate/generating-down-migrations

💯 1

🙇 1

Takeo Kusama

06/28/2022, 10:11 AM

It’s exactly what I wanted. Thanks.

👍 1

Takeo Kusama

06/28/2022, 11:41 AM

I realized rollback my dev database to point I want to do so, and re-migrate. For someone in same situations, I wrote what I did.

Copy code

1. create database for shadow_database
2. remove migration files temporally you want to rollback
3. run `prisma migrate diff --from-schema-datamodel prisma/schema.prisma --to-migrations prisma/migrations --shadow-database-url "${SHADOW_DATABASE_URL}" --script > down.sql`
4. run `prisma db execute --file ./down.sql --schema prisma/schema.prisma`
5. delete records from _prisma_migrations you rolled back

prisma migrate dev

detect conflict and intend to reset migration even if migrate records have marked as applied or rollbacked column, so you need delete migration records in development. If you need to keep migration files for production already applied, restore remove migration files and applied.

Copy code

prisma resolve (--rolled-back or --applied)

20 Views

Open in Slack

Previous Next