P
Prisma•6d ago
ididit

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
Prisma AI Help
Prisma AI Help•6d ago
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?
Nurul
Nurul•5d ago
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.

Did you find this page helpful?