Create initial Database migration file from already developed DB

Hi all, I'm new to Supabase and I'm really enjoying it so far.

I have 2 Supabase projects that is reflecting Prod and Dev.

Dev is the one I've been developing and Prod is newly created with a fresh database.

I want to create an initial migration file that recreates the current state of the Dev database that I can apply to Prod.

How can I do that?

Can I use a command in the Supabase CLI to acomplish that?

/Mike

silentworks•1/29/25, 5:16 PM

You can do a db dump with the CLI https://supabase.com/docs/reference/cli/supabase-db-dump. You can pipe this into a migration if you wish or just follow the command and send it to a schema.sql file.

MikeOP•1/29/25, 6:46 PM

What about running db diff?

MMike What about running db diff?

silentworks•1/29/25, 6:50 PM

The command is there.

MikeOP•1/29/25, 6:50 PM

Yeah.. I mean more how does it compare to doing a db dump?

MMike Yeah.. I mean more how does it compare to doing a db dump?

silentworks•1/29/25, 6:51 PM

The docs should state the difference, you can also test the two to see which gives you better result.

MikeOP•1/29/25, 9:19 PM

I did a supabase db pull and that seem to work great

Create initial Database migration file from already developed DB

Similar Threads

Similar Threads

Similar Threads