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

      Post a Comment

      Popular posts from this blog

      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...
      Post a Comment
      Read more

      Create bulk Sub site Using power shell script using custom SharePoint template

      #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://xxxx.sharepoint.com/sites/sPOTest2/" $Context = New-Object Microsoft.SharePoint.Client.ClientContext($Site) $Creds = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Username,$Password) $Context.Credentials = $Creds $csvLocation = "C:\Users\AA82211\Desktop\PS_SiteCollectionsToCreate.csv" $csv = Import-Csv $csvLocation #List Custom Templates $Templates = $Context.Site.GetWebTemplates("1033","0") $Context.Load($Templates) $Context.ExecuteQuery() $...
      Post a Comment
      Read more

      Business-critical processes with SharePoint and SQL

      SharePoint 2010 provides the ability to connect to backend business systems, surface business data in SharePoint and make it accessible by, and useful to, employees across the organization. Almost every company of significant size uses ERP and CRM solutions to run core business processes. Over time, companies have developed detailed practices around using such systems to support vertical disciplines within the organization (e.g. product planning, financial performance management, supply-chain management, etc.),  yet challenges remain with regard to driving visibility and collaboration, based on business data, across different disciplines and teams. These challenges stem from the fact that only a fraction of employees are licensed and trained to use those backend systems, and from the high cost and complexity of integrating such systems across different functions and teams. With SharePoint and SQL, once the relevant business data is surfaced in an enterprise-wide...
      Post a Comment
      Read more