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.
@Mike_Johnson
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.
Also populate the values of the column 'secret’ in the ‘users’ table with those from the old instance’s users table. An UPDATE join Query should work.