WSS3.0 to SharePoint Foundation 2010 upgrade

migrationsharepointsharepoint-2010wss-3.0

I've got a Windows 2003 x86 server with a small WSS3.0 installation. Now we've bought a new server with Windows Server 2008 x64 and installed SharePoint Foundation 2010 on it. I wish to transfer the few lists and their view from the old WSS3 to SP2010.

How should I do this? All the migration websites I've read talk about preparing, but no-one really say how to migrate from one x86 2007 server to a x64 2010 server.

Cheers

Nik

Best Answer

You will want to do what is called a "database attach upgrade" of your 2007 data. The basic outline of what happens is that you:

  • setup your SharePoint 2010 farm (make sure that all the settings are setup how you want them, and that you include all custom/3rd party solutions and web parts)
  • backup your SharePoint 2007 database(s)
  • restore your database(s) to the SharePoint 2010 Database
  • Add your new database/site to the SharePoint 2010 farm using the command:

    stsadm -o addcontentdb -url <URL> -databasename <database name>
    (this will upgrade your database to the 2010 format at the same time)

  • Upgrade the site(s) to use the new SharePoint 2010 interface

Here are 2 blog posts that walk you through the database attach upgrade procedure: http://sharepointgeorge.com/2009/upgrading-content-db-sharepoint-2010-part-1-preupgradecheck/ http://sharepointgeorge.com/2009/upgrading-content-database-sharepoint-2010-database-attach-method/

Also, check out this chart from Microsoft to see all of the available upgrade options.