Changes to schema.prisma
Whenever I want to push changes to a model in my schema.prisma, it asks me to delete all the available data first. Is there a way to get around this? What is the standard way of pushing up changes I make to my db?
SUse prisma migrate to generate migration sql files that can be applied to the db without dataloss: https://www.prisma.io/docs/concepts/components/prisma-migrate
Prisma
Prisma Migrate is a database migration tool available via the Prisma CLI that integrates with Prisma schema for data modeling.
SOr if you use planetscale, check out this video for best practices and db devleopment pipeline: https://www.youtube.com/watch?v=iaHt5_hg44c
YouTubePrisma
In this video, you will learn about everything you need to know when using Prisma with PlanetScale.
We'll dive into:
We'll dive into:
- Referential integrity and operating without foreign key constraints
- Migration workflows with Prisma and PlanetScale using the
commandprisma db push - Defining indices on relation scalars (the foreign key fields).
