SharePoint 2010: Migrate Sharepoint 2007 to Sharepoint 2010

SharePoint 2010: Migrate Sharepoint 2007 to Sharepoint 2010

Below is a step by step guide that I recently used to migrate MOSS 2007 to Sharepoint 2010.

If you are using MOSS 2007 pre SP2, you will not be able to upgrade directly to 2010. You will need to upgrade your 2007 install first to MOSS 2007 SP2. You can download SP2 install from here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b7816d90-5fc6-4347-89b0-a80deb27a082&displaylang=en

Everybody has different methods they prefer for migration, I do not prefer in-place upgrades as it can be risky and time consuming if all fails. The method below involved building a server beside the existing server and a copy of the data is migrated across and upgraded. Once complete you may reconfigure your AAM and network to access the new server.

First you must ensure that you meet the pre-requisites for Sharepoint 2010 (as there is quite a jump). It can only be installed on 2008 R2 64bit servers and even more importantly SQL backend must also be the 64bit R2 version of SQL server. Requirements are as follows:

Sharepoint/Front end servers:

Hardware : 64 bit, 4 cores - 4GB RAM (Developer) 8GB Production - 80GB HDD

Software: The 64-bit edition of Windows Server 2008 Standard, Enterprise, Data Center, or Web Server with SP2, or the 64-bit edition of Windows Server 2008 R2 Standard, Enterprise, Data Center, or Web Server

Database/Back End servers:

Hardware: 64-bit, four cores for small deployments. 64-bit, eight cores for medium deployments - 8 GB for small deployments, 16 GB for large deployments - 80GB HDD (Depends on your data really)

Software: The 64-bit edition of Windows Server 2008 Standard, Enterprise, Data Center, or Web Server with SP2, or the 64-bit edition of Windows Server 2008 R2 Standard, Enterprise, Data Center, or Web Server

The 64-bit edition of Microsoft SQL Server 2008 R2.

Upgrade process:

  1. Install your SQL server and Sharepoint server as per usual install procedure.
  2. Export your database from your existing SQL database server. I would simply do a full backup of the existing data.
  3. On the destination server, do a database restore using the backup file created in step 1. Specify the database name to be WSS_Content (if that is what you are using) and make sure you go to options and tick overwrite existing database (WITH REPLACE).
  4. Create a New site in sharepoint Administration Console and delete its existing content database.
  5. Open up Sharepoint Management Shell and perform following commands:
    1. "Test-SPContentDatabase – Name WSS_Content -WebApplication http://myapp" - This command will test and verify that your database can in fact be upgraded
    2. "stsadm -o addcontentdb -url http://myapp -databasename WSS_Content" - This command will add the content database and upgrade it to 2010 format
  6. Verify that the upgrade was completed successfully by first navigating back to Central Administration / Application Management / Manage content databases, which now displays the upgraded database.

Depending on the size of your database the full upgrade may take a few hours. Even though the admin console may say that it is finished upgrading in the "Check Upgrade Status" page, it may not display on your site for a while. I had to leave my install for a full day before being satisfied with the upgrade.

Once upgraded you will realize that the new look/feel is still the same as MOSS 2007. That is because the UI version needs to be upgraded (for each and every site). To change the look and feel run the following commands in the Sharepoint Management Shell:

$web = Get-SPWeb http://myapp
$web.UIVersion = 4
$web.UIVersionConfigurationEnabled = 0
$web.Update()

Once the above command completes you should now be able to browse your Sharepoint 2010 server with the new look and feel.

Leave a Comment
  • Please add 3 and 7 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Gokan Ozcifci edited Revision 4. Comment: title change  

  • Richard Mueller edited Revision 3. Comment: Removed (en-US) from title, added tags

  • Craig Lussier edited Revision 1. Comment: added en-US to tags and title

Page 1 of 1 (3 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Great article ! could you please made an HOW to from it? or put some images?

  • Craig Lussier edited Revision 1. Comment: added en-US to tags and title

  • Is there any acrticle to migrate SP'03 to SP'10?? I вщтже know how to get all site collections...

  • Is there any acrticle about SP'03 to SP'10 migration? I don't know how to get all site collections...

    Thanx

  • Richard Mueller edited Revision 3. Comment: Removed (en-US) from title, added tags

  • Gokan Ozcifci edited Revision 4. Comment: title change  

Page 1 of 1 (6 items)