WSS3.0 to SharePoint Foundation 2010 upgrade

Question

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

Solution

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.

Comments

[user35132]

Thank you very much! :-) Just a short question, since this is a small site running WSS, it uses SQL Server Express (default when WSS3 was set up). How should I back up this database. There is no SQL Management Studio for that, right? And the SharePoint 2010 Foundation didn't have a SQL Server 2008 pre-installed, so I expect it has also deployed an SQL Server Express instance, how should I restore to this one? Are there any tools you could recommend? Finally, for this upgrade option, does it include my views?

[MattB]

This is actually a free version of SQL Server Management studio available for both 2005 and 2008. microsoft.com/downloads/… microsoft.com/downloads/…

[user35132]

Thanks a bunch, I'll try that out first thing monday :-)

[sush]

Thanks from me to, I'd also found the TechNet prep, but no actual doing it