Migrate from SharePoint 2010 to SharePoint 2013 – Step by Step

So you are excited by SharePoint 2013’s new features and tend to migrate from SharePoint 2010 to SharePoint 2013? Well, this article walks through moving from SharePoint 2010 to SharePoint 2013 step by step, assuming all necessary migration preparations and planning strategies are done, lets move to the core migration process.

Before you start:

  • Change the Authentication to Claims: Claims authentication is the default authentication in SharePoint 2013. Many dependent services (like Office Web Apps) require Claims authentication in SharePoint 2013. So before migration, convert your SharePoint 2010 web applications from Classic mode (which is the default in SharePoint 2010) to Claims. Technet Reference: http://technet.microsoft.com/library/gg251985 Also, If you have “Forms” authentication, make sure it’s configured in your target farm before migration.
  • Cleanup Before Migration – Clean up an environment before an upgrade to SharePoint 2013 – This includes deleting unused sites/site collections, removing unused features and solutions, Delete orphaned users and sites, Cleanup old document versions, removing features that are not supported by SharePoint 2013 (such as Web Analytics). Technet Reference: http://technet.microsoft.com/en-us/library/ff382641.aspx
Its recommended that you run database consistency check before taking database backup from SharePoint 2010 farm.

No more In-place upgrade from SharePoint 2010 to SharePoint 2013! In other words – No direct upgrade is possible from SharePoint 2010 to SharePoint 2013. You can’t install SharePoint 2013 on top of SharePoint 2010 (as we can install SharePoint 2010 on top of SharePoint 2007). So only migration is allowed in SharePoint 2013. You can’t re-use your existing Hardware for SharePoint 2013 (Also you can’t install both SharePoint 2010 and SharePoint 2013 on the same machine).

Migration Steps Summary:

  1. Create new SharePoint 2013 Farm, Setup necessary configurations.
  2. Backup – Restore SharePoint 2010 Content Databases to SharePoint 2013’s SQL Sever (or perform a detach-attach process)
  3. Verify content databases by running: Test-SPContentDatabase from the Target SharePoint 2013 farm.
  4. Attach Content Databases to SharePoint 2013 web application by running: Mount-SPContentDatabase
  5. Upgrade Site Collections to move them into SharePoint 2013.

Step 1. Create New SharePoint 2013 Farm:
Install and configure new SharePoint 2013 farm. All farm configurations should be setup as in source SharePoint 2010 Farm, including: All necessary configurations like AAM, Email settings, Managed pats, etc. Install any 3rd party software, language packs, custom features and solutions you had in your SharePoint 2010 farm into your new SharePoint 2013 Farm. Create web application(s) to SharePoint 2013
environment as in your existing SharePoint 2010 farm.

As we are going to use the existing content database from SharePoint 2010, Delete the default content database associated with your new web application. If you failed to delete the web application’s root site database, you will get “Orphaned Sites” issue on running Test-SPContentDatabase cmdlet as part of migration process. This is because the root site collection exists in both content databases and leads to conflict!

Alright, This article assumes new SharePoint 2013 Farm is already installed and configured.

Step 2. Backup – Restore SharePoint 2010 Content Databases to SharePoint 2013 SQL Sever: 
Backup SharePoint 2010 content databases, Restore them into SharePoint 2013’s SQL Server instance.
Migrate from SharePoint 2010 to SharePoint 2013
Identify and take a list of your source content databases either from Central Administration (Central Administration >> Application Management >> Manage Content Databases )
get all content databases of a web application
Or use this PowerShell cmdlet to retrieve all content databases of a particular web application:

Get-SPContentDatabase -WebApplication "<Web App URL>" | Select Name
Optionally, you can Setting SharePoint Content databases to read-only before taking backup. But why? because you may want users to continue using SharePoint 2010, same time preventing any data in-consistency on content migrated to SharePoint 2013. To do so: Go to SQL Management Studio >> database properties >> Options >> Set Database Read-only to “True”.

Backup Databases from SharePoint 2010 SQL Server:

  1. Log-in to SQL Server box of your SharePoint 2010 Farm
  2. Open SQL Server Management Studio, Expand Databases node
  3. Right Click your content database, Choose Tasks >> Backup backup SQL Server database
  4. Set the backup type to “FULL”, specify the backup destination and click on “OK” to start backup processbackup SharePoint content database in SQL Server Management Studio
  5. Wait for the backup to complete.SharePoint content database backup

Repeat this procedure for All content databases of desired SharePoint 2010 web applications.

Restore Database on SharePoint 2013’s SQL box:
The next step is to restore all databases taken from SharePoint 2010 to SharePoint 2013 SQL Server. sql server 2012 management studio

  1. Copy all required databases backup files to your target SharePoint 2013’s SQL Server.
  2. Open SQL Server Management Studio Right click databases node >>Click Restore DatabaseRestore SQL Server Database
  3. Specify the source as “Device” and click on the “…” button to add backup files. Click on the “Add” button to locate backup files.
  4. Once done, click on “OK” to return to the restore window. Locate SQL Server backup source
  5. In the Destination section, you can type a new database name in the Database field if you wish to rename your database.Restore SharePoint Databases in SQL Server
  6. Click on the “OK” button to start the restore process. Wait for the restored successful message.SharePoint Content Database Restore
  7. Once restored, Go to Database properties, Click on Options Tab, Set Database Read-only to False. (If you made it read-only before taking backup!) Set SharePoint Content Database to Read-only

Step 3. Verify content databases with Test-SPContentDatabase: 
No more STSADM -o PreUpgradeCheck and its replaced with the PowerShell cmdlet: Test-SPContentDatabase. So we got to execute Test-SPContentDatabase cmdlet which scans content databases of the provided web application and addresses any issues found.

Syntax:

Test-SPContentDatabase -Name <Database name> -WebApplication  <Web-App-URL>

E.g.

Test-SPContentDatabase -Name "SP2013_Operations_Content" -WebApplication "http://SharePoint13.Crescent.com"

This would report potential issues such as: Missing Features & Solution dependencies, Orphaned Sites, wide Lists, etc. Resolve Migration issues reported by Test-SPContentDatabase.
Test-SPContentDatabase Issues

Test All Content Databases and produce Report
Lets execute Test-SPContentDatabase for all Content Databases:

Add-PSSnapin Microsoft.SharePoint.PowerShell -EA SilentlyContinue

#Array to hold Content Databases to Test
$ContentDBS= ("SP2010_IntranetRoot_Content", "SP2010_Sales_content", "SP2010_Operations_Content")

#Web Application to Host
$WebAppURL = "http://SharePoint13.Crescent.com"

#Loop through each web web application
Foreach ($DB in $ContentDBS)
{
     "Checking Content Database - " + $DB | Write-Host -ForegroundColor Green

      "Report to Content Database: $($db)" |  Out-File -Encoding default -FilePath $("D:\DBCheck.csv") -Append 
      #Test Content Database and output report to a CSV file
      Test-SPContentDatabase -Name $DB -WebApplication $WebAppURL | ConvertTo-Csv -NoTypeInformation | Out-File -Encoding default -FilePath $("D:\DBCheck.csv") -Append
}

This script gives nice report in CSV format for easier analysis. To troubleshoot upgrade issues reported, use http://technet.microsoft.com/en-us/library/cc262967.aspx

Check the upgrade log and deploy any missing components and re-run Test-SPContentDatabase cmdlet to verify again. Make sure UpgradeBlocking is false to move further!

Step 4. Attach Content Databases to SharePoint 2013 by running: Mount-SPContentDatabase
After fixing all issues reported by Test-SPContentDatabase, we can start attaching content databases to SharePoint 2013 web application. Remember: Always mount the root site collection’s database first! Also, if you migrating My sites, Migrate My Site Host First!

Mount-SPContentDatabase -name "SP2013_Operations_Content" -DatabaseServer "G1-SP2013-DB01.Crescent.com" -WebApplication "http://sp13.crescent.com" -confirm:$false

Once mounted the content database to web application successfully, The site collection is accessible in SharePoint 2010 Mode!

Step 5. Upgrade Site Collections to move them into SharePoint 2013.
One more step to complete our migration: Upgrading site collections. By default, after migrating from SharePoint 2010 to SharePoint 2013, All migrated site collections will be on SharePoint 2010 format, retaining its old look and feel and other functionalities. We’ve to explicitly migrate all site collections to SharePoint 2013.

This can be done by Site collection administrators by clicking links from upgrade reminder banner.

At Site Collection Level, you can make use of Site Collection Health Checkup:
New in SharePoint 2013, Site collection Administrators can perform health checkup at site collection level before upgrading site collections from SharePoint 2010 mode to SharePoint 2013! Navigate to

  • Site Settings >> Site Collection Administration
  • Click on Site collection health checks (Or use PowerShellTest-SPSite -identity <URL>)

Site collection health checkup report gives customized files, missing galleries, missing Content Types, content type conflicts, missing site templates, unsupported language packs, etc. You can repair some of the issues by running: Repair-SPSite -identity <URL>
Site collection Health Checkup

Deferred site collection upgrade
Its a replacement for Visual Upgrade feature (Once site collection is upgraded, can’t be rolled back). SharePoint 2013 shipped with files to Support SharePoint 2010. Not just user interface but actual SharePoint functionality itself. E.g. You can find 14 folder on SharePoint 2013 installation. So all files will still be maintained. E.g. Features, Event Receivers, Solutions can be deployed on 14 hive, etc. So, almost all of your existing SharePoint 2010 customizations should just work fine.

You will see a banner on top of Site collections now!

To upgrade the site collections: Click on the “Start now” link on the banner (You can get there by going to Site Settings >> Site Collection Upgrade as well.)
Upgrade SharePoint 2010 Site Collections

Confirm the site collection Upgrade
upgrade site collection 2
We can monitor the upgrade progress with SiteUpgrade.aspx page, which provides a link to an upgrade log for troubleshooting purposes. From here, you can either start the actual upgrade or create a preview site.
Monitor Upgrade Status
SharePoint Farm Administrators can do it through bulk through PowerShell script:

Upgrade-SPSite -identity "http://sharepointsite" -VersionUpgrade

We can upgrade all site collections under the specific web application with PowerShell cmdlet:

#To upgrade all site collections in a Content Database
Get-SPSite -contentdatabase <content database name> -limit All | Upgrade-SPSite -versionUpgrade

Once upgrade completed successfully, Verify Your site collection is with all new SharePoint 2013 features.
SharePoint 2013 Upgrade Progress

Get Upgrade Status:
Upgrade can be time consuming where there is a large number of site collectionsexists on the given content database. Get the Status of  upgrade from “Upgrade Status” page in central administration page (Central Admin >> Upgrade and Migration >> Check upgrade status )!
upgrade status
Or use the PowerShell script:

Get-SPSiteUpgradeSessionInfo -contentdatabase "<Content DB Name>" -showInProgress -showCompleted -ShowFailed

Sites will be in locked state until upgrade completed.

That’s all, We are completed now! As a best practice, Review event logs and ULS logs after migration completed successfully!!

Here is our SharePoint 2010 site:
sharepoint 2010 to sharepoint 2013 migration
Here is the SharePoint 2010 site migrated with SharePoint 2013:
sharepoint 2010 to sharepoint 2013 upgrade
The Final site after site collection upgrade:
upgraded sharepoint 2013 site

Additional Things to Consider:

You can try the Demo Upgrade with Evaluation Site Collection:
Demo upgrade allows getting the SharePoint 2013 preview of the existing site collection by making a copy. You can try it by clicking the “Try a Demo Upgrade” link either from the “Upgrade Reminder banner ” or by going to Site Settings >> Site Collection Admin Site collection upgrade, click on Try a demo upgrade

Site collection admin receives an email when timer job “Create upgrade Evaluation Site Collections” creates a site collectiondemo site req received

Farm administrators can request an Evaluation Site Collection using PowerShell:

Request-SPUpgradeEvaluationSite -identity <Site Collection URL>

This Provisions a temporary site collection with SharePoint 2013’s look and feel to validate your site collection to get the preview of your site collection on SharePoint 2013. Remember, the evaluation site collection expires after 30 days, and gets auto deleted!
sharepoint 2010 to sharepoint 2013 migration step by step

Remember, while upgrading: you can’t downgrade! Meaning, you can’t upgrade from SharePoint Server to SharePoint Foundation or You can’t upgrade from SharePoint Server Enterprise to Standard version!

Disable Self Service Upgrade
In some cases, you may want to disable self-service upgrades on specific site collections, e.g. You may want to disable upgrade on heavily customized site collections. We can disable the upgrade which hides the “upgrade Reminder” bar at the top of the site collection eventually.

#Get the site collection
$Site = Get-spsite "http://Intranet2013.crescent.com/sites/operations"
#Disable Upgrade options from UI
$Site.AllowSelfServiceUpgrade = $false

This disables upgrade options from site the collection by removing the upgrade banner and the “Upgrade Site Collection” button from Site collection upgrade page of site settings. So now, the only option to upgrade is: using PowerShell cmdlet: Upgrade-SPSite

What about Migrating Service Applications?
Just because you can migrate service applications, doesn’t mean you must! Consider upgrading service applications from SharePoint 2010 to SharePoint 2013 when you have some critical data in it and it involves lot of time to re-do!! I’m keeping it aside for now, will cover this in an another article.

Upgrade from SharePoint 2007 to SharePoint 2013
Want to migrate from MOSS 2007 to SharePoint 2013? Sure, But there is no way to migrate from SharePoint 2007 to SharePoint 2013 directly! We’ve to Migrate from MOSS 2007 to SharePoint 2010 first (can use Staging environment for this!) and then perform SharePoint 2010 to SharePoint 2013 migration again (Or you can use 3rd party migration tools to upgrade from SharePoint 2007 to SharePoint 2013 directly) Read my related posts:

References:
I would strongly recommend to go through these excellent technet resources:

Salaudeen Rajack

Information Technology Professional with Two decades of SharePoint Experience.

9 thoughts on “Migrate from SharePoint 2010 to SharePoint 2013 – Step by Step

  • May 8, 2020 at 3:54 PM

    Does content db backup and restore approach migrates custom permission level?

    Reply
  • January 10, 2018 at 6:55 PM

    Do we need to migrate users during 2010 to 2013 upgrade, since default 2013 web applications will be Claims mode authentication?

    Reply
    • January 11, 2018 at 6:29 AM

      Yes! If you are using “Classic” mode authentication in SharePoint 2010, You should migrate to Claims.

      Reply
  • October 26, 2016 at 1:31 PM

    All, have you ever migrated running workflow states and content from SharePoint 2010 to SharePoint 2013? Can this be done through DB attach and detach method? If not, can advise the possible solutions? Thanks a lot!.

    Regards.

    Reply
  • December 2, 2015 at 5:14 PM

    Thanks for sharing, covered great details!!!

    Reply
  • October 29, 2015 at 8:50 PM

    During testing noticed that migrated sites with lists that had the Title field renamed had reverted back to “Title. Is there a setting in the migration schema to prevent this?

    Reply
  • June 18, 2015 at 7:45 AM

    Hi! Nice to meet you.,

    I understand your meaning “SharePoint 2013 shipped with files to Support SharePoint 2010. Not just user interface but actual SharePoint functionality itself”., I check control templates in 15 HIVES, they reference Microsoft.SharePoint.WebControls Version 15. When I open control templates in 14 HIVES, they reference to Microsoft.SharePoint.WebControls Version 14. Could you please explain me how SharePoint 2013 manage these 2 dll? Because as of now, in 15 HIVES folder ISAPI I can see Microsoft.SharePoint dll version 15.
    But in 14 HIVES, this dll doesn’t exits. Could you please explain me these 2 dll stored?
    Many thanks.

    Reply
  • October 8, 2013 at 7:18 PM

    I really like the sentence in the 1st paragraph when you say “assuming all necessary migration preparations and planning strategies are done” because I think that this phase is absolutely necessary and sometime taken not seriously enough. Regarding the 3rd party tool for the SharePoint migration, Sharegate has a very good one that is user friendly and accessible. There’s a 15-day free migration that gives you the opportunity to try it or a free webinar every Thursday that gives you details on the tool. Nonetheless, a SharePoint migration is a laborious process and the step-by-step articles like this one are very convenient!

    Reply

Leave a Reply