Looking to sync two supabase projects
We are wanting to set up a new project as a "playground" environment for our clients to test out integrations and different features we have without effecting their production data. We were hoping that supabase had a way to resync data for a project based on a backup of another, but it looks like it's not possible.
I tried doing this using
I also tried using the supabase cli, but couldn't find a way to reset a project based on a dump file or backup.
Has anyone done this before? What would be the best way to handle this?
I tried doing this using
pg_dump, but ran into issues with permissions around triggers or other schemas. Granted, I am not very experienced in this. I also tried using the supabase cli, but couldn't find a way to reset a project based on a dump file or backup.
Has anyone done this before? What would be the best way to handle this?
