Migrating MOSS 2007 SSP/MySites to SharePoint 2010 in a database attach scenario

So you have decided to upgrade your MOSS 2007 farm to SharePoint 2010.  You’ve reviewed the two supported migration techniques and decided to start fresh with a new SharePoint 2010 farm on new hardware and/or VMs and use the database attach method…

using the new SharePoint 2010 Mount-SPContentDatabase PowerShell cmdlet in the SharePoint 2010 Management Shell, you will be attaching and upgrading your old 2007 content dbs following the straight forward TechNet documentation …

…but how do you migrate your Shared Service Provider user profiles and your MySites to SharePoint 2010 in the database attach scenario now that the SSP has been replaced by service applications?

The documentation is there, but is not explicit, on TechNet(!)  Here are some more detailed steps on how to migrate your old MOSS 2007 SSP User Profiles and MySites to your new SharePoint 2010 farm:

1. Backup your existing MySites content database(s) on your MOSS 2007 farm SQL Server
2. Back up existing SSP database on MOSS 2007 farm SQL Server
3. Move both database .BAK files to the new SQL Server
4. Restore the SSP database from .BAK as database named Profile_DB on your new SQL Server
5. Restore the MySites database from .BAK as database named WSS_Content_MySites on your new SQL Server
6. Create a new Web Application in your SharePoint 2010 Central Administration site to host your migrated MySites content (e.g. http://mysites)
7. Attach and upgrade the restored 2007 MySites database (i.e. WSS_Content_MySites) using the SharePoint 2010 Management Shell
   1. SP-MountContentDatabase –Name WSS_Content_MySites –WebApplication http://mysites
8. Turn off the following services in your SharePoint 2010 Central Administration site 
   1. User Profile Service
   2. User Profile Synchronization Service
9. Delete existing User Profile Service Application(s) if they already exist [Central Administration -> Application Management -> Manage Service Applications]
   1. Make sure to check the box for delete associated data/content
10. Reset IIS
11. Create a new User Profile Service Application in Central Administration [Central Administration –> Manage Service Applications –> New]
    1. Name = User Profile Service Application
    2. Create New App Pool
       1. “User Profile Service Application”
       2. DOMAIN\farm_account
    1. Use the restored 2007 SSP database as the “Profile Database Name” (Profile_DB)
    2. Accept all other default database names
    3. Enter the newly created MySites web application url (e.g. http://mysites) as the default MySites location for the new User Profile Service Application
12. Go to “Administrators” in the ribbon menu for the User Profile Service Application and verify that DOMAIN\farm_account has “Full Control” rights
13. Start the User Profile Service in Central Administration [Central Administration –> Application Management –> Manage Services on Server]
14. Start the User Profile Synchronization service in Central Administration [Central Administration –> Application Management –> Manage Services on Server]
    1. Use DOMAIN\farm_account credentials
    1. This will take a few minutes…
    2. Follow progress in ULSViewer.exe if you are concerned it is failing & filter by Category=”User Profile”
15. Reset IIS
16. In service.msc on your Central Administration host server (i.e. “App Server”), verify the two ForeFront Identity Management Windows services
    1. Services are started
    2. set to startup “Automatic”
    3. Running as DOMAIN\farm_account
17. Setup Profile Import [Central Administration -> Manage Service Applications -> User Profile Service Application - click on title]
18. Click on the link to “Add New Synchronization Connection” [see examples below]
    1. Name = DOMAIN
    2. Forest Name = sub.domain.local
    3. Specify a DC = dc.sub.domain.local
    4. Authentication = Windows Authentication
    5. Account Name = DOMAIN\ad_sync_account
       1. Make sure your chosen account has “Replicating Changes” rights in AD [for more details refer to this article]
    6. Click “Populate Containers”
    7. Click “Select All”
    8. “OK”
19. Run a Full Import
    1. Central Administration –> Manage Service Applications” -> “User Profile Service Application” -> “Start Profile Synchronization” -> select Full Import radio button option
    1. This will take a few minutes..
20. Setup Profile Sync schedules [Central Administration –> Monitoring –> Timer Jobs]
21. Test the MySites site with a domain user account…success!

Related posts:

1. Deleting orphaned service (web) application pools in SharePoint 2010 This has come up for me twice this week.  During an initial install a typo...
2. SharePoint 2010 PowerShell Basics  Admittedly, I was not too excited to learn I would need to add yet another new...
3. Service Pack 2 On the heels of releasing a release roadmap and new official name for SharePoint “14”...
4. MOSS 2007 OTB Usage Reports A colleague asked last week if anyone on the team had a definitive list of...
5. SharePoint 2010 Links and Resources Here are some SharePoint 2010 links I’ve collected so far…...