sync local db with remote db
🌲branching
CLI🟢SQL
CLI🟢SQLhey guys,
so, i've been using supabase straigth from dashboard and it was fine.... until yesterday... i want to start to use it with docker but i cannot sync it with remote... let me break it down
i've been using supabase writing sql queries on
-
-
-
-
-
-
-
- supabase cli is on latest version
at this point i really thought local db would be synced with remote, but it didn't. My issue is basically the same on here,
still no luck... already deleted the docker containers & volumes, did this process several times and still, no luck at all...
then, i started to find something that could possibly help me, then i found this video https://www.youtube.com/watch?v=N0Wb85m3YMI - and tried to use it but the problem is, my migration folder on supabase has only a few migrations that i have done "" in the right way "" in the past, so they basically have only a few modifications done, not the whole database tables and triggers and functions and everything else.
so... i have a shell script to fetch all the tables and everything else from this project and i have them saved here... if i simply copy and paste them into my local supabase, this local will be kinda similar to my remote, but it won't be the full remote state... so, how can I fix this and start to using
so, i've been using supabase straigth from dashboard and it was fine.... until yesterday... i want to start to use it with docker but i cannot sync it with remote... let me break it down
i've been using supabase writing sql queries on
sql editor-
supabase init-
supabase start-
config.toml[analytics] enabled = true-
supabase login-
supabase link --project-ref ... Finished supabase link-
supabase seed buckets --localsupabase seed buckets --linked-
supabase migration fetch --linked- supabase cli is on latest version
2.75.0at this point i really thought local db would be synced with remote, but it didn't. My issue is basically the same on here,
still no luck... already deleted the docker containers & volumes, did this process several times and still, no luck at all...
then, i started to find something that could possibly help me, then i found this video https://www.youtube.com/watch?v=N0Wb85m3YMI - and tried to use it but the problem is, my migration folder on supabase has only a few migrations that i have done "" in the right way "" in the past, so they basically have only a few modifications done, not the whole database tables and triggers and functions and everything else.
so... i have a shell script to fetch all the tables and everything else from this project and i have them saved here... if i simply copy and paste them into my local supabase, this local will be kinda similar to my remote, but it won't be the full remote state... so, how can I fix this and start to using
YouTubeSupabase
Day 2 - Supabase Local Dev: migrations, branching, and observability: https://supabase.com/blog/supabase-local-dev?utm_source=youtube&utm_medium=social&utm_term=launch-week-8&utm_content=N0Wb85m3YMI
Database Branching allows an ephemeral database to be created for every Git branch. This means entirely separate databases for Local Development, P...
Database Branching allows an ephemeral database to be created for every Git branch. This means entirely separate databases for Local Development, P...
