Migrate a content database from SharePoint 2007 to 2010

Referred URL - http://blog.armgasys.com/?p=106

SharePoint 2010 support two methods for migrating and upgrading a SharePoint 2007 install

Method#1
In place upgrade.
This is very simple and straightforward.  You insert the SharePoint 2010 DVD, run the “is everything ready for an upgrade” wizard, and then perform the upgrade.  You just have to remember all things SharePoint 2010 are now 64bit.

Method#2
Migrate and upgrade individual web applications and content database.
This is known as the Database Attach Method of upgrading and is (based on my experience) the most common upgrade SharePoint users will encounter.

In this post, we will be reviewing the steps for performing method #2 upgrades.

Step#0 – Backup everything related to the content database you are migrating
Nuf’ said!

Step#1 – Attach the SharePoint 2007 content database to the new database server
This step only applies if you are also migrating to a new database server during the SharePoint 2010 upgrade process.  If you are not changing database servers, skip to step#2

For SQL Server 2005 users, see the following MSDN article
http://msdn.microsoft.com/en-us/library/ms190209(SQL.90).aspx

For SQL Server 2008 users, see the following MSDN article
http://technet.microsoft.com/en-us/library/ms190209.aspx

Step#2 – Create a new web application in SharePoint 2010
To upgrade a content database, you must first have a SharePoint web application created which will connect to and consume the soon to be upgraded content database.

1. Launch the SharePoint 2010 Central Administration web site
2. Select Manage Web Applications  under Application Management
3. Click “New” on the ribbon
4. Configure the new web application to fit your needs
   NOTE: Take the defaults for Database Name.  See Step#3 for more details.

Step#3 – Delete the content database which was just created in Step#2
Yes, you read correctly, delete the content database.

1. Launch the SharePoint 2010 Central Administration web site
2. Select Manage Content Databases under Application Management
3. Select the web application created in step#2 from the web application drop down loaded in the upper right of the screen
4. Click on the Database Name which was created in step#2
   It will be named something like WSS_Content 1234ab-cfe1234-443abc-1234ab
5. Scroll to the bottom of the database information page displayed and check the Remove Content Database checkbox
6. Click the OK button

What is happening here?
SharePoint requires a target web application for ALL content databases. Why? Because the web application determines which features are supported and installed for all content hosted by that web application.  When the actual migration process occurs, the upgrade software scans the content database for all of the features being used by the content (I.E. lists, document repositories, third party, web parts, etc) and then determines if the target web application supports that feature.

The problem we encounter is that SharePoint has nicely created an empty content database which we are never going to use because we already HAVE a content database.  So, we need to perform a little bit of cleanup work.

Step#4 – Validate the SharePoint 2007 content database can be upgraded
SharePoint contains a PowerShell cmdlet which will validate the content database against the web application created in Step#3.

1. Launch SharePoint Powershell
   Start –> All Programs –> Microsoft SharePoint 2010 Products –> Management Shell
2. At the prompt, type the following PowerShell command
     Test-SPContentDatabase –Name “Database Name” –WebApplication [url]Example
   Test-SPContentDatabase –Name “Content DB” –WebApplication http://test.site.com
   Will test the content database named Content DB against the existing web applicationhttp://test.site.com
3. Review the output for any issues listed as Upgrade Blocked: Yes
   Any issue listed as Upgrade Blocked will need to be corrected.

Step#5 – Mount the database onto the web application created in Step#3
This step will upgrade and mount the database against your newly created web application

1. Launch SharePoint Powershell
   Start –> All Programs –> Microsoft SharePoint 2010 Products –> Management Shell
2. At the prompt, type the following PowerShell command
   Mount-SPContentDatabase –Name “Database Name” –WebApplication [url]