How do I transfer a Neon database from one Vercel org to another?
Basically the title. Someone has a Vercel organization on Neon with a couple databases. I've added him to my Vercel organization, which I assumed would make him a part of my Neon organization. But for him, my Vercel organization doesn't pop up on Neon. How can we do the transfer? According to Neon I manage organization members through Vercel.
6 Replies
adverse-sapphire•4w ago
Hey! Unfortunately project transfers are not currently supported for Vercel-managed organizations. I recommend migrating your database using pg_dump/pg_restore, or using our import data assistant. The assistant option makes it quite easy to move your database.
You might find these docs useful : https://neon.com/docs/import/migrate-from-postgres#pgdump-and-pgrestore-example
https://neon.com/docs/import/import-data-assistant
painful-plumOP•4w ago
hey @Sam , sounds good. I will use the import data assistant. but can you tell me why i cant seem to do it even though i already have a vercel neon project created? am i not able to use a Vercel org neon database for this?
painful-plumOP•4w ago
it is prompting me to make a new one, not sure why
xenial-black•4w ago
So sorry, it's just the way the tool was built. The primary use case was migrating to Neon from another Postgres platform, so it assumes you need to set up a project in that flow.
painful-plumOP•4w ago
all good, so i should just make a fresh neon db and forego the vercel organization?
adverse-sapphire•4w ago
Yes, I would make a fresh Neon organization, then dump/restore into a new project there.