Skip to main content

SharePoint User Profile Service Migration SP 2010 - SP 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}

      Comments

      Popular posts from this blog

      Build and Deploy a custom theme in SharePoint 2019: Using C# and Site features

      Custom Theme and Branding are common to use cases and all kinds of business users like to have the personalized team and collaboration sites. today I am posting C# code that will help to build custom features for SharePoint 2019 site.   If need any assistance, I would be happy to help: kamal_pandey@outlook.com  ----------------------------- Code to build  custom features---------- using System; using System.Collections.Generic; using System.Globalization; using System.Linq; using System.Text; using System.Threading.Tasks; using Microsoft.SharePoint; using Microsoft.SharePoint.Utilities; namespace SharePointBranding.Code {     public class BrandingManager     {         public SPWeb Web { get; set; }         public BrandingManager(SPWeb web)         {             Web = web;         }         public void SetMasterPage(stri...

      PowerShell For create Sub site in office 365

      #Add references to SharePoint client assemblies and authenticate to Office 365 site Add-Type -Path "\Software\SharePoint 2013 Client Browser v1.7\Microsoft.SharePoint.Client.dll" Add-Type -Path "\Software\SharePoint 2013 Client Browser v1.7\Microsoft.SharePoint.Client.Runtime.dll" $Username = Read-Host -Prompt "Please enter your username" $Password = Read-Host -Prompt "Please enter your password" -AsSecureString $Site = "https://XXXXXXX.sharepoint.com/sites/Test2/" $Context = New-Object Microsoft.SharePoint.Client.ClientContext($Site) $Creds = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Username,$Password) $Context.Credentials = $Creds $csvLocation = "C:\Users\PS_SiteCollectionsToCreate.csv" $csv = Import-Csv $csvLocation #List Custom Templates $Templates = $Context.Site.GetWebTemplates("1033","0") $Context.Load($Templates) $Context.ExecuteQuery() $Templates | Whe...