How to to migrate new local db to schema which I have in prod?
Hi all, so we have two supabase instances prod and dev. We are developing against dev at the moment. With the release of supabase CLI, it looks like it would be much easier to handle migrations via CLI instead of doing it manually.
To enable CLI usage in our project, I'm trying to migrate freshly set local db schema to what we have in dev currently. So we can start developing in local environment and then push db migrations to the dev via generated scripts.
I initialiazed a Supabase project in our repo via
Then I did a schema dump from dev via pg_dump, then created a blank sql migration script via
How can I apply those scripts to my local supabase instance?
I found how to push it to remote, but not to the local
To enable CLI usage in our project, I'm trying to migrate freshly set local db schema to what we have in dev currently. So we can start developing in local environment and then push db migrations to the dev via generated scripts.
I initialiazed a Supabase project in our repo via
supabase initThen I did a schema dump from dev via pg_dump, then created a blank sql migration script via
supabase migration new and put a pgdump result there. How can I apply those scripts to my local supabase instance?
I found how to push it to remote, but not to the local
