Quick question. Can prisma handle migrations of pr...
# orm-help
m
Quick question. Can prisma handle migrations of procs? And how would I do that?
r
@Melvin Gaye 👋 This is possible with Migrate via the following steps: 1. Create the migration file via
prisma migrate dev --create-only
2. Add the proc to the
.sql
file. 3. Run
prisma migrate dev
to apply the migration. The proc will also be created as Migrate executes the SQL written in the migration file
m
Oh boy oh boy, you just saved me a bunch of work ahahah ty!
🙌 1