Migrating SharePoint 2013 applications to SharePoint 2016

       Take backup from the SP 2013 SQL Server.

·         Steps for restoring the SharePoint 2013 application DB to 2016 DB.
 

-- Get the backup from the SharePoint 2013 DB.
-- Go to the SharePoint 2016 DB server and open the SQL Server Management Studio.
-- Right click on the ‘Databases’.
-- Click on the ‘Restore Database’.
-- Select the ‘Device’ option
-- Click on ‘Add’ from the pop-up screen as below.
-- On clicking of ‘Add’, one more pop-up will be opened and browse to the location where the database backup is located and select the backup folder and click ‘ok’.
-- Again click ‘ok’ as shown in below screen.
-- Rename the database that to be created in 2016 as shown below
-- Then click ‘ok’ for restoring. 
-- Once the database restoring is done, a message will be shown
-- Verify that the database comes up in the ‘Databases’ list.

Create a Web Application in SharePoint 2016

-- Run the Test-SpContentDatabase command in powershell against the restored database on the web application in SharePoint 2016 environment.

“Test-SPContentDatabase –Name <SP2013_Application_DB> –WebApplication "<SP 2016 Application Name>"

-- Fix the issues that were shown in the above command.

-- Once they are fix, run the Mount-SpContentDatabase command in powershell against the restored database on the web application.

Mount-SPContentDatabase –Name <SP2013_Application_DB> –WebApplication "<SP 2016 Application Name>"

-- when you run the Mount-SP command, you may encounter with an issue related to Visual Upgrade in SharePoint 2010.

Issue - Content Database data integrity check has encountered a severe issue that upgrade process must be stopped.

when you check the logs, you will see the number of sites which are still in SP 2007 look and feel, for which when you migrated your application from MOSS 2007 to SP 2010, might not been done a visual upgrade.

-- So fix the issues, go to SharePoint 2013 environment and run the below script

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

 $webApp = Get-SPWebApplication "<SharePoint 2013 Application URL>"

$sites = $webApp.Sites

foreach($site in $sites)

{

Upgrade-SPSite $site.RootWeb.Url -VersionUpgrade -Unthrottled

$site.Dispose()

}

the above command will do a Visual Upgrade for all the sites under the application which are not visually upgraded.

-- Once the above PS script is completed,again you have to follow the steps from above like 

 taking the DB backup - restore- Test-SPContentDB - Mount-SPContent.

-- Once the Mount-SPContent command gets executed, you are done with migration of the SharePoint 2013 application to SharePoint 2016.