Restored a copy of the 2010 database for MySites to my test server
Removed the content db in CA
Detached the db in SQL
Attached the restored copy in SQL
Added the content db in CA
Do an iisreset
Now ready for some test runs…
Test-SPContentDatabase -name MySites -webapplication https://server:3334 | out-file e:upgradeupgrade.txt -width 500
Got some errors about missing webparts or customizations which is fine, I don’t want to use them anymore anyway. Most errors are regarding the office web apps though but none of them is blocking upgrade so I will go ahead:
Category : MissingFeature
Error : True
UpgradeBlocking : False
Message : Database [MySites] has reference(s) to a missing feature: Id = [893627d9-b5ef-482d-a3bf-2a605175ac36], Name = [PowerPoint Mobile Viewer], Description = [Enables viewing of PowerPoint presentations in the mobile web browser], Install Location = [MobilePowerPointViewer].
Remedy : The feature with Id 893627d9-b5ef-482d-a3bf-2a605175ac36 is referenced in the database [MySites], but is not installed on the current farm. The missing feature may cause upgrade to fail. Please install any solution which contains the feature and restart upgrade if necessary.
When this was done, I just detached the db from SQL, copied it to my new SP2013 server and then it is ready to be migrated.
Did the same on the SP2013, that is remove the content db from the MySites web app. Attach it on the SQL and then in CA again:
But then you cannot add the content db directly from CA, you need to mount it:
Mount-SPContentDatabase “MyDatabase” -DatabaseServer “MyServer” -WebApplication http://server:5230
After mounting I got this message
Yeah I have a look later, I think I know what the error messages is. I had a customized template for the MySites on my 2010 server and that is not included in this upgrade. Will just skip it and proceed.
Made an iisreset
Got access denied when trying to access MySite (the old classic Access Denied message from 2010) as my self:
Signed in as the administrator and that MySite which I could access (so only Admin could access MySites right now)
Got the message about upgrading the site collection so I did that by clicking “Start now” up in ribbon:
Upgrade-SPSite http://server:5230/personal/lr00554 -VersionUpgrade
Tried to access my personal MySite again, but still access denied “Site has not been shared with you”
I looked at the Authentication Provider for my MySite web app and that said “Claims based authentication” but maybe all site collections are not included? My last test was to upgrade the authentication for entire web application including all migrated mysite site collections.
Convert-SpWebApplication -Identity “http://server:5230” -To Claims -RetainPermissions [-Force]
And TADA, the new MySite is up and accessible!