Hi everyone! I’m planning to move our small SaaS app’s user accounts from our own PostgreSQL database into Auth0. We have about 500 users right now.
I’ve read the docs but feel a bit overwhelmed by the actual steps. Could someone share a simple, practical guide? I’m especially unsure about:
- How to format the user data for the bulk import.
- Handling passwords securely during the move.
- What to check right after migration to make sure logins still work.
Any tips or lessons from your own migration would be super helpful! 😅
Hey, that's exactly what I did for my side project a few months back! 500 users is a great size to tackle this.
For the bulk import, the JSON format is pretty straightforward but watch out for the `email_verified` field - you gotta set that to `true`, otherwise your users will get blocked by a verification step they never signed up for. Auth0's import tool will accept a CSV too, but JSON gave me fewer hiccups.
On passwords, you can't migrate them directly unless you have them in plaintext (which you absolutely shouldn't). You'll need to use the "Password Migration" flag in your import file. This triggers Auth0 to email your users a one-time link to set a new password. It's secure, but be ready for some support emails from confused users.
Big tip: before you flip the switch, migrate just ONE test user first. Use that account to check login from your app post-migration. Then do the rest in a batch. Also, turn off any cron jobs that might modify your old user table while the import is running!
Beta tester at heart