How to Upgrade SharePoint 2007 to SharePoint 2010
(Part 1 of 3)

Published by on January 12th, 2012

It’s hard to believe that it’s 2012 already, but for all of you SharePoint users out there, this means one thing: It’s been over five years since SharePoint 2007 (MOSS/WSS) was released. My assumption is that all of you are aware that SharePoint 2010 is out there by now, and if not, well perhaps you have traveled to the wrong website.

Just like any “new and improved” Microsoft product that’s released, many end users are hesitant to upgrade right away. Simple math tells you that SharePoint 2010 has been used for over two years, and now that all the guinea pigs have ironed out the wrinkles, guess what? It’s time to upgrade!

Upgrading SharePoint 2007 to 2010

So, what are you waiting for? Order the software, throw the CD in the drive and click Setup! Not so fast… SharePoint is not your average Microsoft software that allows you to click Next a couple times and you’re done. There is a whole lot of planning that needs to go in to upgrading from your 2007 version to 2010, and the Fpweb.net SharePoint experts are here to walk you through it.

System Requirements

First of all, you can’t upgrade anything unless you have the correct software and hardware. Allow me to point out the most important requirements for SharePoint 2010. (I won’t bore you with all the granular requirements such as hard drive space, memory, processor speed, etc… Those can be found here.)

  • You must be using 64-bit hardware.
  • Windows 2008 or Windows 2008 R2, both also must be 64-bit.
  • SQL Server 2005 SP3 or SQL Server 2008 SP1 or later. Again, 64-bit edition.

Pre-Upgrade Check

There are a few different upgrade methods that I will describe more in depth in Parts 2 & 3 of this 3-part series. Before you take any approach, you must ensure that your current 2007 SharePoint environment is ready to be upgraded. Microsoft has made this fairly easy for us by introducing the Pre-Upgrade Check utility. This option is only available with Service Pack 2 (or later, as SP3 has recently been released) for MOSS and WSS. Now is a good time to update to Service Pack 2 or 3, because you cannot upgrade to SharePoint 2010 without it. To run the pre-upgrade check, open the command prompt and enter the following STSADM command: STSADM.exe –o preupgradecheck as shown below:

pre upgrade check

*Note: if stsadm.exe is not a recognized command, you must browse to the following directory: (*COMMONPROGRAMFILES*)\Microsoft Shared\Web Server Extensions\12\bin\

This is what I like to call a successful pre-upgrade check. Notice there are no errors. Now you may be wondering, where do I find the information for the “Information Only” values above? When the pre-upgrade check completes, it will automatically open the SharePoint Products and Technologies Pre-Upgrade Check Report in a browser window. Needless to say, if any of the above values result in errors, please view the report and resolve any errors prior to proceeding with the upgrade.

This next step might seem a little obvious, but you would be surprised. You now want to browse to your SharePoint site(s) and ensure that all sites and features are working properly. Depending on the size of your site, this could be very time consuming. This is very important because it can help alleviate some of the post-upgrade pain you may experience if you realize there is an issue on your site after the upgrade. If this was a pre-existing condition, you can’t exactly blame it on the upgrade. This is especially important if you perform an in-place upgrade, as you will not be able to compare the pre-upgrade and post-upgrade sites side by side. Which leads me to my next point…

BACKUPS!

Now that you have all of the correct hardware, and you know your site is fully functional and ready for an upgrade, it’s time to take a backup. It is HIGHLY recommended to take a full backup of your entire environment prior to upgrading. It doesn’t matter if you have a vanilla install, or a highly customized/feature-full environment. BACKUP, BACKUP, BACKUP! It is well worth the extra storage space, time and cost (if applicable).

Things to Consider

  • If your current environment resides on a 32-bit operating system, it must be moved to a 64-bit prior to performing an upgrade.
  • If the need to copy large databases over a network, plan for the bandwidth usage accordingly.
  • Perform a upgrade using a test or development environment prior to performing on production environments.
  • Perform cleanup tasks on retired data prior to upgrading to shrink the size of the database(s) and shorten the overall upgrade time.

Up Next: Upgrading from SharePoint 2007 to SharePoint 2010: Part 2 of 3 (Introduction to Upgrade Methods and Their Pros & Cons) Stay Tuned!

Need help upgrading or migrating your SharePoint environment? Have further questions about the upgrade process? Please contact Fpweb.net, world leaders in Microsoft SharePoint hosting.

About Joe Beyer

Joe Beyer has written 26 posts in this blog.

If Joe's not busy administering SharePoint, he's busy learning more about it, cause let’s face it…no one knows everything about it. Joe builds and maintains many of the SharePoint environments, ranging in size from single to multi-server. He's a huge fan of the Cardinals and Packers and Joe recently hitched a ride on the Crossfit bandwagon and has yet to fall off. He enjoys hunting and fishing any chance he can get, primarily at the Lake of the Ozarks. Keep up with Joe on Twitter @JoeRBeyer or
Follow Joe on Google+

VN:F [1.9.22_1171]
Rating: 9.8/10 (4 votes cast)

 
  1. GNewman
    June 7th, 2012 at 09:57 | #1

    I see here you referenced needing to migrate from a 32 bit version of 2007 to 64 bit. Could you explain why? I am running into an issue where I think this might be a factor and I want to know: 1) What is the issue that would be caused by migrating straight to 2010 with out the middle step of migrating to 64 bit 2007? 2) What are the steps involved besides this if there are any? 3) I’ve been told that when it comes back out that the April cumulative update for Sharepoint 2010 will be essential to complete this process, is that True?

  2. June 25th, 2012 at 06:39 | #2

    @GNewman

    Hi GNewman,

    Sorry for the delayed response. In order to install SharePoint 2010, you need 64-bit HARDWARE. I would like to answer any remaining questions you may have. If you could be a bit more specific in those questions, I would happy to answer them the best I can.

    Thanks!
    Joe

  3. SPAdam
    July 30th, 2013 at 09:19 | #3

    SharePoint Migration is always a complex process and has multiple stages starting from Planning to Post migration fixes.  I Use this guide to Migrate from MOSS 2007 to SharePoint 2010:Migrate from MOSS 2007 to SharePoint 2010 – Step by Step

  1. September 3rd, 2013 at 15:45 | #1