I am trying to script a mass update of usernames (logins) for some of my iMIS records. They are quite a number of them (over 40,000 records). Is it as straightforward as running an update script to update the userid column on usermain table and username column on the aspnet_Users table?
I have tried this on my test environment and iMIS seems to lose the user record after this update. When I try to update anything on the user credentials page and save, I get the error message "Error: The user was not found".
Can anyone help please?