What's a good flow for making sure migrations are applied to prod
I am using Drizzle with Supabase in my Next.js website. Locally I have ran
drizzle-kit generate and drizzle-kit push. I do have some updates in my supabase/migrations folder that were committed in my PR. What's a good flow to make sure these changes get made to my prod DB? Run these commands locally but pointed to my prod DB? Or is there a proper way?2 Replies
I would like to know myself, I can’t even get the migrations outside of my very first one to propagate over to Supabase.
For the longest time I was just running the generates and pushes locally against the prod env variables but I feel like that isn't the right move.