Configure Automatic Migration from Your Database
After you create a database connection in the Dashboard, you enable user migration from that database and create custom scripts to determine how the migration happens.
These custom scripts are Node.js code that run in the tenant's sandbox. Auth0 provides templates for most common databases, such as: ASP.NET Membership Provider, MongoDB, MySQL, Oracle, PostgreSQL, SQLServer, Windows Azure SQL Database, and for a web service accessed by Basic Auth. For more information on implementing these scripts, see Authenticate Users using a Custom Database.
Create a new database connection in the Connections > Database section of the Dashboard.
On the Custom Database page, enable the Use my own database option:
- On the Settings page for your database, enable the Import Users to Auth0 option:
Configure the scripts
On the Custom Database page, under Database Action Scripts, you will see the Login and GetUser scripts you need to configure.
The Login script executes each time a user that is not found in Auth0 database attempts to log in. It verifies that the user exists in the legacy database without prompting the user for their password again.
The Get User script executes following any of these actions:
- A user attempts to sign-up.
- A user clicks on a valid password change confirmation link.
- The Management API receives a call to the update a user's email or username endpoint.
Passwords for Un-Migrated Users
If an un-migrated user confirms a password change, their user profile will be created in Auth0 with the new password. This user profile will contain all the information returned in the Get User script. All subsequent logins of this user will be performed in Auth0 directly.
You may see unexpected behavior if you return differing user profiles in the
Verify the migration
After you've enabled migration, you can verify the users that have migrated by doing one or both of the following tasks:
Convert the database
Once all your users are in the Auth0 database, you are ready to convert the database to Auth0.
Go to your custom database connection on the Dashboard.
Update the Login Database Action Script to the following:
- Update the Get User Database Action Script to the following:
By doing this, you are changing the Login and Get User Database Action Scripts to NO-OP functions.
Disconnect the legacy database
After you have verified the migration, you can disconnect your legacy database (not the Auth0 database).
Keep Import Users to Auth0 (on the Settings page) enabled. Your users will then be directed to use the new database workflow.
Configure rules to execute other functions when a user authenticates to your application.