Best way to clone a database for testing?
Currently we have 2 separate databases running (dev and production). I want to clone the production database to test our migration changes on it first, before we push the same to our actual production.
What's the best practice to handle this? I was thinking of cloning the whole public and auth schema in our current production, but I'm not sure if it would totally work since I'm not sure which schemas are closely tied with the actual supabase project.
What's the best practice to handle this? I was thinking of cloning the whole public and auth schema in our current production, but I'm not sure if it would totally work since I'm not sure which schemas are closely tied with the actual supabase project.
