Transfer a database to the customer's pro account
Hey together,
i am wondering what the easiest way is to move/copy a whole project or at least it's entire database scheme over to my customers freshly created pro account, so they have sovereignity over their data in case i am not here anymore or get kidnapped by a turtle randomly at night. I've read that i could add them as team member to my project (that i used for dev). But what are the next steps to make this safe and almost 0 f*** up guaranteed?
Thank you so much for your help! If we ever meet, i'll invite you to a drink ❤️
Peter
18 Replies
You invite them to your account/org as a team member. Make them owner of the org (preferably with only the one project in the org). Then they drop you as owner.
Another way is similar but they make you owner of the org you want to go to... you transfer to project to that org. Then they remove as owner.
Hey @garyaustin! Thank you so much for your fast reply. That sounds nice. So as soon as the project goes over to the other account everything stays functional? Or do i have to edit some .env files and adjust?
Nothing changes in the project if the org changes ownership or even if you transfer it between orgs.
❤️ that is so smooth.
transfer might be better than first way if it is a pro org as they would not have your billing info.
so my case is: i use a free plan (for now) to integrate supabase to my dev project i do for my clients. i then ask them to get a pro plan for supabase so we have backups etc. and use it for production.
So you could just change owners of the 1 project free plan and then they go pro...
Or you can be allowed ownership for a bit to their pro org to transfer the project to it. I believe you can then drop being owner or for sure they can drop you being owner.
oh it's different accounts. my customers use their email to get the pro plan
Yes.
ok cool!
Orgs are pro or not, not accounts.
You just don't want a pro org you have (with your billing) be switched to them as the new owner as it would still be your billing.
Transferring the project only to their new org is the best way.
so let's say i got my account with my own "org" and my email (free plan) and my customer has his own account registered (which i want to transfer the project to) with his own org and email (the customers org is not in my account) - i invite them to my account and then revoke my access? (sorry, i am probably confused as hell) 😄
You are not inviting them to your account. You are inviting them to your org. So once they are also owner they can drop you as owner and then also turn it into a pro ORG with their billing. They could do that with you as owner also, but up to them.
Ah! Got you. And if my customer already created a Pro Org in their account?
At some point you both have to be owners of orgs to transfer between orgs, or transfer org to them.
Then they make you owner temporarily in their ORG and you do a TRANSFER from the project to their ORG which should be an option to you as you are an owner for that period of time.
https://supabase.com/docs/guides/platform/project-transfer
Thank you so much austin! Will try that right away.
Are you involved with supabase? If so: keep on doing what you do! ❤️ Really really loving supabase so far.
Supabase comps the mods for their time. They are putting quite a bit of money into open source helpers and helpers here and github.
And thanks for answering in the middle of the night. Really appreciating it! 🙂 If you have a donate button or anything, lemme know.
Oh you are a mod. I am a bit slow with discord. Still used to mIRC. 😄
Thank you. I could successfully prepare the transfer! Wish you a good one.