2

I have been trying to fix this problem, I could not search any documentation for this specific problem. I have everyhing setup, the project is linked, the docker is running, I just can not figure out the way to pull data from my production database in supabase portal into my database in local environment

Any form of help is appreciated

Jan Cahlík
  • 91
  • 6

1 Answers1

1

You can use supabase db remote commit to capture any changes required for your local database to match the schema of your remote Supabase project.: https://supabase.com/docs/guides/cli/local-development#link-your-project

thorwebdev
  • 818
  • 4
  • 9
  • 2
    Following up on thorwebdev answer: Be aware that if you do the supabase db remote commit it will not apply any changes you did to the AUTH schema or Storage schema. So if you have triggers or policies for those schemas then you have to write the SQL in that migration. – Inb4cookies Mar 15 '23 at 09:14
  • @Inb4cookies why is that? Can you point us to the documentation explaining this? – Carles Mitjans May 16 '23 at 13:29
  • @carlesMitjans This was not supported in earlier versions. I think this is available now. https://github.com/supabase/cli/issues/96 since this issue is closed. – Inb4cookies May 17 '23 at 11:59