Migrate a SharePoint 2007 Site to SharePoint 2010

Once I had a user requirement to migrate a SharePoint 2007 site to SharePoint 2010. There are several methods to do this task. I used following method because I need to retain the original values of Modified Date, Created Date, Created By, and Modified By from the SharePoint 2007 site.

Before starting the migration, it’s better to keep a backup of the content database and also need to install SharePoint Service Pack 2.

Get a copy of the Content database of SharePoint 2007 site

·         Go to Microsoft SQL Server Management Studio.

·         Right-click on the content database and select Tasks à Backup…

·         Enter the Backup Name

·         Select the Destination on Disk, and click OK to start the backup of the Content database.

·         Then copy the backup file to the SharePoint 2010 SQL server

Create a new Web application in SharePoint 2010 server

·         Create a new empty Web application on the SharePoint 2010 server,

·         If there are any custom solutions which installed on SharePoint 2007, then install those solutions to the new Web application on the SharePoint 2010 server

Restore the SharePoint 2007 backup file to SharePoint 2010 SQL Server

·         Open Microsoft SQL Server Management Studio on SharePoint 2010 SQL Server.

·         Right-click on Databases and select Restore Database

·         Give a Name to the database (do not use any existing name because this will overwrite)

·         Select the Source for restore as From Device and give the path to the backup file which is copied from SharePoint 2007 server.

·         Click OK to start

Dismount the content database from new SharePoint 2010 web application

·         Open SharePoint 2010 Management Shell

·         To dismount the current SP2010 content database run the following command

      Dismount-SPContentDatabase <ContentdBName>

ContentdBName : content database name of the new SharePoint 2010 web application

Mount the content database to the SharePoint 2010 server

·         Verify that all the needed custom components. If there are any errors, make sure you correct them before mounting the SP2007 content database.

Test-SPContentDatabase -Name < newContentdBName > -WebApplication <URL>

·         If get errors, so add the solutions to the SP 2010 site

Add-SPSolution -LiteralPath <path to the solution>

·         Install Solution

Install-SPSolution -Identity <solution name> -WebApplication < URL > -GACDeployment 

·         If no error, then Mount-SPContentDatabase cmdlet. This cmdlet also upgrades the SP2007 content to SP2010.

Mount-SPContentDatabase <ContentDb> -WebApplication http://<SiteName>

SiteName : The new 2010 site

Visual Upgrade

After upgrading from SharePoint 2007 to 2010 it will give the SharePoint 2007 user interface. To upgrade the to the SharePoint 2010 look and feel:

·         Login as Site Owner and select Site Actions à Visual Upgrade.

·         Select Update the user interface.

·         Click OK. It will upgrade to the SharePoint 2010 look and feel