Migrate Content Database From SharePoint 2013 To SharePoint 2016

Today we are writing about how to take content Database and restore the same to SharePoint 2016.
We are migrating SharePoint 2013 Content Database to SharePoint 2016. We have the case summary for the same, just for an example we have a content database on SP 2013 site which we want to migrate the same Site collection and information on new environment on SharePoint 2016.

To do this follow the below Steps,

  • Before doing this make sure you have Farm administrator rights with your user account.
  • Login to SharePoint 2013 environment which you want migrate onto SharePoint 2016. Then click on SharePoint central administrator 2013 and define which content Database you are going to migrate and find the SQL database Name as well.
  • We need to verify App Management which we want to migrate from the same.

To do above: Login CA>Application management>Manage Web Application> defined the Web App

  • Now we need to go back to view all site collections under the Application management, and define web application and select which you have defined earlier from Web Application. Below is the screen shot:



  • Go back to SQL server and take backup for Database and save in local system. To take full backup of Database using SQL server management Studio see URL
  • Once backup is done follow URL, we have posted recently about restoring the DB.
  • Now go back to Central admin site and check Managed content database and you can see still we could not find any database on the same.
  • Go to the attached Content database we need to run restore or mount and attach database to see the result.
  • Run the following statement via SharePoint Management Shell.

Mount-SPContentDatabase "your_db_name" -DatabaseServer "your_sqlserver" -WebApplication

  • See the below result how it would be: maybe it we will run all commands and together we will get some errors, so we can run like below as well.



  • Now go back to Central admin and select Manage content Database from Application management and Database options.





  • Go back to Site collection and select view all site collection and verify all sites have been created and opened successfully with all data.



  • Now open the created site or migrated site and verify site is getting open.

Ebook Download
View all
Learn
View all