Migrate User Credentials to new Production Server

(Mike Johnson) #1

We have a server with 65 users that encountered some issues in a software upgrade, so we have chosen to install a new server and migrate data into the new server. We have migrated the user accounts using Export-Import functionality, but we would appreciate some guidance on the different options for migrating user credentials to the new server, so that we do not have to process password resets for 65 users.

Thank you.

cc @dhis2-backend

How to import user details including passwords using the user/userCredentials resource of WebAPI
(Emma Kassy) #2

After using the Export-Import Functionality, you could use SQL to query the old instance for passwords based on UID (this should be similar in both instances) and then use an UPDATE query in the new server to populate passwords to pre-existing usernames.