i:0#.w|Ali.Mazaheri

Azure, Open Source, SharePoint and ...

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

Note: This post is based on Beta 2 and is subject to change in future releases.

I highly recommend to review the Services upgrade model and User Profile Service overview on SP 2010 TechNet site before trying the following steps to upgrade a MOSS 2007 SSP database and My Site content to SharePoint Server 2010.

image

Upgrading SSP

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

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.
image

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

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

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

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

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

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

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.
image

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.
 image

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.
image

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.
image

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

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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

image
image