When and how to run prisma migrate deploy? I can't...
# prisma-migrate
d
When and how to run prisma migrate deploy? I can't run it from my CI/CD since it doesn't have access to the production Postgres (not part of the VPC and shouldn't be), so when should it be done? And how...?
n
I have the same issue when doing manual migrations. Could you get a VM or VDI?
d
Nope, not as part of the CI/CD. Or at least not in a way that is cost effective.
j
Hi! So the best is when the hosting platform provides a “release phase” like Heroku https://devcenter.heroku.com/articles/release-phase Basically you want to only run the database migration after the build succeeds.
On AWS some people are opting for a separate lambda that does the migration and they trigger it from their pipeline, example: https://prisma.slack.com/archives/CBFFY3066/p1621544329006700?thread_ts=1621367609.000500&cid=CBFFY3066