Everyone is talking about upgrading from SharePoint 2007 to SharePoint 2010 and what is the best way to do this?
Well the answer is not straight forward, you need have a lot of information on the current environment, planning, understanding, planning, resources and uhm planning. Then you will be able to either do an in place upgrade, a database attach upgrade or a combination of the two.
In this post I will briefly cover the attach database upgrade method.
Basically this method is a little more subtle than the in place upgrade and can be slightly more tedious but a lot safer.
Firstly you create a new SharePoint 2010 server built on Windows 2008 x64 using SQL 2008 x64. You can find the list of prerequisites here http://technet.microsoft.com/en-us/library/cc262485.aspx. However the SharePoint 2010 package does come with a checker that you can run before installing 🙂
You will now need to make a backup of the SharePoint 2007 SQL content database of the web application you are trying to upgrade and Restore this backup to your SQL 2008 x64 server (I will refer to this server as 2008SQLServer) you are using for SharePoint 2010. (I will refer to the restored database as MOSS2010_Content_Demo)
To ensure your upgrade will be successful you will need to run the following Powershell command and work your way through the expections. You need to use SharePoint 2010 Management Shell to execute this command. It will output a pretty HTML document located at C:upgrade.html
Test-SPContentDatabase -name MOSS2010_Content_Demo -WebApplication http://2010demo.local -ServerInstance 2008SQLServer convertto-html > C:upgrade.html
You will need to review this list fix the items on SharePoint 2007 and SharePoint 2010, once this has been done backup and restore the SQL database and run the command again.
Everything done? GOOD!
Your machine is up and running and you have created a new Web Application (I will refer to this app as http://2010demo.local) please remove the current Database attached to your web application. You can do this by going to Databases under Applcaition Management and click on Manage Content Databases. From this area you will be able to remove the content database selected.
Now your Web Application has no database to point to!! Don’t panic we will assign a new database.
Run the following command and replace the obvious.
stsadm -o addcontentdb -url http://2010demo.local/ -databasename MOSS2010_Content_Demo
This should kick off the upgrade process. Once completed it will leave you with a log file file and hopefully a successfully upgraded SharePoint 2010 site.