Keeping two Supabase projects in Sync Prod|Dev
For my App I have 2 environments dev|prod, and the supabase Url/anon key are linked to different branches of my repo (main | dev...etc) . For some additional features I made changes in the database schema and I want to translate those errors to the production database, I've been doing this manually but I feel is error prone, any suggestions?
The first time I created the prod environment I used pgAdmin schema backup to create an exact copy, I want to see exactly which changes have been made to the dev database since, and implement them in prod before I push my code to prod. Thank you!
The first time I created the prod environment I used pgAdmin schema backup to create an exact copy, I want to see exactly which changes have been made to the dev database since, and implement them in prod before I push my code to prod. Thank you!
