Migrate prisma lost data
Hello there, I have an issue while I try to migrate something.
While preforming that command :
npx prisma migrate dev --create-only --name rename-column a SQL file is created so I modify it by :
ALTER TABLE "Token" RENAME COLUMN "token" TO "tokens"; and I still lost my data inside that column. Is this even possible to rename a column without lost all datas ??3 Replies
You decided to hold for human wisdom. We'll chime in soon! Meanwhile,
#ask-ai is there if you need a quick second opinion.Hey 👋
Yes, it's possible.
Does this guide help you?
https://www.prisma.io/docs/orm/prisma-migrate/workflows/customizing-migrations#example-use-the-expand-and-contract-pattern-to-evolve-the-schema-without-downtime
Customizing migrations | Prisma Documentation
How to edit a migration file before applying it to avoid data loss in production.
Hello, no it dont.
Still losing data from the column i want to change