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

Ich habe in der letzten Woche mal wieder eine Migration von MOSS auf SharePoint 2010 bei einem Kunden durchgeführt. Die Herausforderung bestand diesmal in der Übernahme aller Profile und MySites in das neue System da wir bei der Einführung des Systems die MySite Profile erweitert haben. Eine einfache Übernahme der MySites hatte ich bereits erfolgreich durchgeführt, jedoch die Profildaten auf SP2010 mitzunehmen war Neuland.

Wie immer bin ich Recht schnell fündig geworden mit welchem Workaround das Problem bewältigt werden kann. Im Blog von Ali Mazaheri sowie Joel Oleson wird beschrieben wie man die Profildaten mittels SSP Datenbank migrieren kann – die beschriebene Methode funktioniert soweit:

Quelle: Ali Mazaheri MSDN Blog

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.

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&gt; -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.

Quelle: SharePoint Joel

Some people are saying.  I’m having a problem upgrading the SSP with Database Attach upgrade.  Looks like I’m getting forced to use In-Place upgrade.

While There are some simple ways to upgrade search and single sign on with powershell scripts, the profile and audiences are more difficult.

I’ve been mentioning for some time that the way to upgrade the SSP database in a database attach method of upgrade is by using mount-spcontentdatabase.  Someone mentioned they had tried that and failed.

Ali Mazaheri has some good examples of doing this in his blog: Upgrading MOSS 2007 SSP User Profiles and My Site Content using Db Attach

There are some key pre-requisites before upgrading your SSP database:

1. Create a web app

2. Ensure the service app – managed metadata service is enabled (YES, this is a DEPENDENCY)

3. Ensure the Profile Service is up and running – and you should upgrade this database first with the special powershell cmdlet

If you are creating it fresh, you can use:

New-SPProfileServiceApplication -applicationpool <ApplicationPoolName> -Name <ServiceApplicationName> -Profiledbname <DatabaseName> [-Profiledbserver <ServerName>]

4. Create a new relationship/proxy for the User Profile Service App and ensure it is in the default proxy group.  You can do this in central admin or in powershell.

New-SPProfileServiceApplicationProxy -ServiceApplication <ProfileServiceApplicationID> -Name <ProxyName> -DefaultProxyGroup

5. Ensure the profile sync service is running

Note: The Profile Sync Service app Service Account for the profile sync job must be server admin, this is a FIM requirement.  Michael Noel uses a dedicated server for profile sync if the customer is concerned about the security/permissions.  Note the service

6. Upgrade the mysites before the SSP is mounted


Ultimately I think upgrading the services by doing an in place upgrade on the SSP is a decent way of upgrading the configuration.  I’m becoming a big fan of hybrid upgrade.


Über Erik Neumann
IT Consultant, MCP, MCTS, MCITP, ecspand your SharePoint! http://www.ecspand.de

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

  1. Suchmaschine says:

    Greetings, this is a genuinely absorbing web blog and I have cherished studying many of the content and posts contained on the web site, keep up the outstanding work and desire to read a good deal more stimulating articles in the future.

Kommentar verfassen

Trage deine Daten unten ein oder klicke ein Icon um dich einzuloggen:


Du kommentierst mit Deinem WordPress.com-Konto. Abmelden / Ändern )


Du kommentierst mit Deinem Twitter-Konto. Abmelden / Ändern )


Du kommentierst mit Deinem Facebook-Konto. Abmelden / Ändern )

Google+ Foto

Du kommentierst mit Deinem Google+-Konto. Abmelden / Ändern )

Verbinde mit %s

%d Bloggern gefällt das: