CODEWITHSUNDEEP
prisma
Jessica
Jessica

Reputation: 9830

Prisma migration error: The database schema is not empty

I have a prisma db and I am trying to run the deploy command for production.

When running yarn rw prisma migrate deploy , I get an error saying:

1 migration found in prisma/migrations

Error: P3005

The database schema is not empty. Read more about how to baseline an existing production database: https://pris.ly/d/migrate-baseline

What am I doing wrong and how can I fix it?

Upvotes: 7

Views: 11671

Answers (1)

damdafayton
damdafayton

Reputation: 2429

If you setted up Prisma on an existing database you must skip initial migration as such:

yarn prisma migrate resolve --applied <migration_name>

Its called baselining.

If it doesnt work due to some existing data, you can either rollback changes or fix the data problem and apply a fix with yarn prisma migrate diff

Details are here.

I ran the diff and applied the resulting file as such:

yarn prisma migrate diff --from-url <DATABASE_URL_PROD> --to-schema-datamodel <path to schema.prisma> --script > forward.sql

yarn prisma db execute --url <DATABASE_URL_PROD> --file forward.sql

Upvotes: 11

Related Questions