Synchronising schema changes across multiple projects
I'm running several Supabase projects, one as a dev environment and several as production environments for different clients, and I'd like to keep the schemas in sync. I.e., if I make changes to the dev project's DB schema, I'd like a way to make an identical change to all production servers. Similar to running a migration script using something like Alembic: https://alembic.sqlalchemy.org/en/latest/.
What strategies do people here have for keeping schemas in sync in such a way? Relatedly, do people have any strategies for versioning various DB/SQL snippets, e.g. keeping these in their repos? Keen to hear how you guys approach this!
What strategies do people here have for keeping schemas in sync in such a way? Relatedly, do people have any strategies for versioning various DB/SQL snippets, e.g. keeping these in their repos? Keen to hear how you guys approach this!
