SharePoint User Profile Service Migration from SharePoint 2010 to SharePoint 2013

SharePoint User Profile Service Migration SP 2010 - SP 2013

Identify User Profile Service Databases -

• User Profile Service Application_ProfileDB_ID
• User Profile Service Application_SocialDB_ID
• User Profile Service Application_SyncDB_ID

Note : Managed Metadata Service must be migrated before mingrating user profile service

• Taking Back Ups of the Identified Databases 
• Log in to you SQL Management Studio and take backups of the above mentioned Databases (good practice is to make them read only before taking backlups -> right click->properties->option->set read only)

• Right click on the DB and select Back up - add the path you want the back ups to be stored 

                                                                             01

02

• Exporting the Encryption Key
• In the Server where User profile Service is currently running opem CMD and go to "%Program Files%\Microsoft Office Servers\14.0\Synchronization Service\Bin\"
• Enter “miiskmu.exe"
• Select export key and click next
• Enter your farm admin account details and domain and next.
• Set the path where the key should be exported
• Click Export

• Restoring Databases in the new SQL server

• Copy the backups to the new SQL server ( Its good to have in the same machine while restoring)
• Open SQL management studio in the new SQL server
• Check Device, Select the Paths of the Databases and click OK

                                                                                                       03

• Creating User Profile Service and Mounting The Databases
• Before Creating the Service Application, User Profile Service in stance should be started
• Central Administration -> Manage Services on server -> Start User Profile Service

   

•     Create new Application Pool for user profile service 

                         New-SPServiceApplicationPool -Name  UserProfileServiceAppPool 

           - Account Domain\Username

             $applicationPool = Get-SPServiceApplicationPool 

           -Identity 'UserProfileServiceAppPool'
                                                                         

•    Create User Profile Service, using the above application pool and the migrated Databases

                      $UserProfServ = New-SPProfileServiceApplication 

          -Name "User Profile Service Application" 

            -ApplicationPool $applicationPool 

            -ProfileDBName "Profile DB Name" 

            -SocialDBName "Social DB Name" -ProfileSyncDBName "Sync DB Name"

• Import Encryption Key
• Save the Exported encryption key in the following location in the application server "c:\\Program Files\Microsoft Office Servers\15.0\Synchronization Service\Bin\"
• Open CMD and go to "%Program Files%\Microsoft Office Servers\15.0\Synchronization Service\Bin\"
• Run the following command

• miiskmu.exe /i c:\\Program Files\Microsoft Office Servers\15.0\Synchronization Service\Bin\keyname {0E19E162-827E-4077-82D4-E6ABD531636E}

                          Note : GUID is always the same