This is a quick how to on upgrading from Sharepoint services 3.0 to Sharepoint Foundation 2010 when using a SQL 2005 server.

Requirements

As you know Sharepoint 2010 needs a 2008 server it will not work with 2003.

You will also need to download sharepoint 2010 and the Cumalative Update for SQL 2005 which will restart it.

Update SQL 2005

You need to update the version of SQL 2005 to support Sharepoint 2010 install, this can’t be done via Windows Update.

Goto http://support.microsoft.com/kb/980176 hit the link at the top “View and request hotfix downloads” (yes its at the top next to the spanner and screw driver (i spent ages looking for the download link at the bottom))

Once you have the email, download the file, extract it (it will ask you for a password which is in the email as well)

Install it

It will restart your SQL server

Install Sharepoint 2010

Download Sharepoint 2010 foundation from microsoft.com

When installing it pick new farm / it will configure, set the location of your SQL 2005 server.

Let it install

Configure the farm

Setup the email config and anything else like search which you want to use.

Install the templates / wsp’s you had running on the old server

Some of them can be found from http://technet.microsoft.com/en-us/windowsserver/sharepoint/bb407286.aspx others you will have to hunt down again and copy to the new machine.

Install is easy

A) Copy the WSP to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN
B) Open command promt (start -> cmd -> enter)
C) Navigate to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN
D) Run “stsadm –o addsolution –filename filename.wsp”
E) Run “stsadm –o deploysolution -immediate -allowgacdeployment –name filename.wsp”
F) Wait for 5 for it to deploy

Repeat for all the solutions you want / need to add

Add a Web Application

Sharepoint will setup one by default but if it doesn’t or you want a diffrent one create it

Prep the database

We would suggest backing up the database before doing this or making a copy of the database and doing the upgrade on the copy.

Open the sharepoint management shell

On the Start menu, click All Programs.

Click Microsoft SharePoint 2010 Products.

Click SharePoint 2010 Management Shell.

Run

Mount-SPContentDatabase -Name <DatabaseName> -DatabaseServer <ServerName> -WebApplication <URL> -Updateuserexperience

Checkout your new sharepoint install

Open a browser and goto the sharepoint web application