Upgrading MOSS 2007 SSP User Profiles and MySite content to SharePoint Server 2010 using DB-Attach method

Upgrading SSP

1. Under Services on Server in Central Admin, make sure both the User Profile Service and the Managed Metadata service are running.

2. Use the “New-SPProfileServiceApplication” cmdlet to create the new user profile service, make sure to use the MOSS 2007 SSP database name you want to upgrade for “ProfileDbName” parameter.

3. At this point SSP database should be upgraded along with two new databases for “Sync” and “Social”.

4. Check the “Upgrade Status” Page and confirm that SSP database upgrade finished successfully.

5. Create a Service Proxy using “New-SPProfileServiceApplicationProxy” cmdlet and pass the ID for the new Profile Service Application provisioned in step 2.

6. Confirm that all user profiles and other settings are imported.

7. From “Manage service application” page, select the upgraded User Profile service application and click “Administrators” icon on the ribbon.

8. Give Search default crawler account “Retrieve People Data for Search Crawlers” permission.

Upgrading My Site host and Personal site collections

1. Run “Test-SPContentDataBase” cmdlet against the 2007 My Site Host content database and resolve the issues as needed.

 

2. After resolving the issues and installing missing DLLs and Features, run the command again to verify there are no further issues with the content database.
 

3. Make sure to remove the default content database when you provisioned the web application for My Site host. 
4. Run the following stsadm command:
stsadm -o addcontentdb -url http://<yourwebappsURL> -databasename <2007 MySite content database> [-databaseserver <the database server from above>]

5. Make sure Upgrade completed successfully by checking the “Upgrade Status” page.

6. After upgrading the content database, go to Manage Service Applications in Central Administration site and click on the upgraded User Profile Service you want to associate with the My Sites and click on “Setup My Sites” link.

7. Enter “My Site Host” URL and “Personal Site Location”, click on “OK” to save the setting and run the IISRESET.

Make sure that all existing content such as documents are accessible in the upgraded Personal site.