I have finished my app, I have been using

npx prisma db

push during my development. Because I ran

npx prisma migrate dev

, it gives me a bunch of error like

permission error

. I am using

heroku Postgres hobby

for my database. Now I am ready to fully deploy the app to Heroku. But I don't know how to get my

schema.prisma

file to Heroku. I dont know how to deploy the database to Heroku Postgres hobby to communicate with my app. What I found online and on Youtube were about #prisma1 nothing about #prisma2. Any help on how to go about this? . Should I deploy this app like a normal NodeJs app to Heroku?

Hey Ezekiel 👋 welcome to our Slack 😄

Should I deploy this app like a normal NodeJs app to Heroku?

That should certainly be feasible!

Because I ran

npx prisma migrate dev

, it gives me a bunch of error like

permission error

. I am using

heroku Postgres hobby

for my database. Now I am ready to fully deploy the app to Heroku.

It sounds like you may be missing the “shadow database” that’s required by Prisma Migrate. You can fix this by creating a second DB on Heroku and use that connection string in your

datasource

for the

shadowDatabaseUrl

field:

datasource db {
  provider          = "postgresql"
  url               = ...
  shadowDatabaseUrl = ...
}

Thanks this works