I have a postgres database on heroku and want to try out the new

prisma migrate

. When I run it, I get a "permission denied to create database" error. Sounds reasonable for me because the database isn't mine but why wants prisma to create a new database instead of the tables?

The early access Migrate requires the role to have the

createdb

privilege. I think it’s due to Migrate creating a shadow DB to store migrations temporarily.

Indeed like @Ryan said. the

prisma migrate

command is better for dev only and you can use

prisma migrate up

when deploying on Heroku. Note: it’s better to post issues and feedback about new migrate in #product-feedback or #prisma-migrate @marvin-amador How does that sound? Did you want to use the Heroku db for development maybe?

@Ryan @Joël Ah okay, so I can't use the Heroku DB for dev and I need a local one? And later I can easily run

migrate up

and everything will be pushed to the production database on Heroku? Sorry for the wrong channel, I will take care of it! 🙂 The new migrate is really cool, makes so many things easier. 🚀

You can use Heroku as a dev DB as long as you have a DB

user

that has access to create a database. If not, you would need to use a local one.