How to copy everything from one supabase project to another? [Reliable & Easy]

[NikhilCodes]

I have this project in supabase, want to copy everything i.e., RPC functions, tables, users, webhooks etc to another project.
How to do that?

[silentworks]

You can do this using the migrate between projects guide https://supabase.com/docs/guides/database#migrating-between-projects

[benjamindonze]

Hello the link is no more accurate where can I find this documentation nowadays`?

[spassos98]

There is a new link about migrating the databases from one project to another one https://supabase.com/docs/guides/platform/migrating-and-upgrading-projects

[jt6677]

Why cannot we have a left click "duplicate"?

[hitmoose007]

The link is not accurate anymore

[timrodz]

Instead of running psql on step https://supabase.com/docs/guides/platform/migrating-and-upgrading-projects#restore-to-your-new-project, I basically did the following:

Supabase > SQL Editor > New Query

1. Dump roles.sql into that query, run everything. If successful, delete contents and proceed to step 2:
2. Dump schema.sql into that query, run everything. If successful, delete contents and proceed to step 3:
3. Dump data.sql into that query, run everything.

Your DB should now be duplicated. Took about 1 min to do all this.

Extra steps:

1. Link your new project ID: supabase link --project-ref <id-here>
2. supabase stop && supabase start to restart it, just in case
3. Generate types to verify everything's looking fresh: supabase gen types typescript --project-id "<id-here>" --schema public > src/dir/to/types.ts

CC @hitmoose007

[tekmen0]

I have 2 versions, prod - dev. I want to copy schemas etc. from dev to prod but not data.

[Aniketkhote]

Same thing i just want to migrate schema and the rpc

[hamzaakramdropslab]

@tekmen0 did you find the solution

[tekmen0]

no, manually copying

[ahmersaud]

if you still havent found any solutions yet,
here is what i found https://medium.com/@christoph.geiser/how-to-duplicate-supabase-database-into-another-project-eb86dbfbeb06
looks like an easy solution instead of manually doing it.