We have a staging enviroment that has been converted from NTLM to ADFS. The user profiles have already been migrated to ADFS. What I realized after the fact is that when we created the staging environment (and before the ADFS conversion), we did not copy over the My Sites content DBs, so there is only a handful of my sites (users who have acess the environment).
My prod environment has 4 My Site DBs:
Whereas staging only has one, the host: SP2013_UAT_Content_MySites_Host
My question is, if I want to copy over the prod my sites, do I need to overwrite the MySites_Host DB in staging or do I just bring over the others?
Is the MySites_Host DB the same as the others or is it some kind of config database that is specific to the instance when SP was installed (like the SP config DB)?
Also, I wonder if I am going to have to remove the my sites web app from the ADFS realm (back to NTLM) before I do this.
Any help is appreciated.