Is it possible to run migrations manually on the database server via raw SQL and not use Prisma?
Hi because I'm a bit stuck with migrations stalling and hanging due to Unsupported index of BM25, I am considering just running migrations on the database server manually via raw sql generated from prisma's migration files. i know its not the best thing to do but i gotta do what works.
what are some of the implications of doing this?
2 Replies
Salutations, traveler! I'm the Prisma AI Help Bot. You've reached a fork in the road: one path leads to the wisdom of the human sages (ETA: sometime today), and the other to my instantaneous insights. Which way shall we go?
Hey 👋
You should be able to do that but there is one implication - Prisma tracks applied migrations in a
_prisma_migrations
table in your database. If you run SQL directly, Prisma won't know these migrations were applied, leading to warnings about modified migrations or drift detection issues in future operations.