Migration Scripts for SharePoint On premise

June 17, 2021 Dellenny

If you want to migrate your environment from old on Premise 2010 SharePoint to Newer one here are some scripts that can help you in some pieces, Like content Database migration , User Profile and Metadata.

Note if you are migrating from SharePoint 2010 to 2016 or 2019 you will need to go step by step you can not jump directly into target environment unless you use 3rd part software:

To Migrate Content Databases:

copy the database from old to new, and make sure you create new web app in the new environment

Mount the database to new environment then run following scripts

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
Test-SPContentDatabase -name WSS_Content -webapplication http://site/ 

Mount-SPContentDatabase "WSS_Content" -WebApplication http://192.168.0.107:9000 
Convert-SPWebApplication -Identity http://shsp2013:9000/sites/BPM  -To Claims -RetainPermissions -Force

Then you will be prompted -from so type Legacy

To Migrate Metadata after mounting it to new environment


Get-SPServiceApplication -Name "Managed Metadata Service"|fl

$app = Get-SPServiceApplication -Name "Managed Metadata Service"
Set-SPMetadataServiceApplication -Identity $app -DatabaseName "Managed Metadata Service_"

To Migrate User Profile after mounting database, run this:



$applicationPool = Get-SPServiceApplicationPool -Identity 'SharePoint Web Services default'

New-SPProfileServiceApplication -Name 'User Profile Service Application' -ApplicationPool $applicationPool -ProfileDBName 'User Profile Service Application_ProfileDB_2' 

sa = Get-SPServiceApplication | ?{_.TypeName -eq 'User Profile Service Application'}

New-SPProfileServiceApplicationProxy -Name 'User Profile Service Application' -ServiceApplication $sa

proxy = Get-SPServiceApplicationProxy | ?{_.TypeName -eq 'User Profile Service Application Proxy'}

Add-SPServiceApplicationProxyGroupMember -member $proxy -identity ""