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

Answer 1

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.

Answer 2

1.Prepare a server with x64 windows 2003 2.Install x64 windows 2003 ; 3.Use stsadm.exe commander to migrate x86 wss3.0 to x64 wss3.0; 4.Upgrade the server with x64 windows 2003 to x64 windows 2008 R2 5.Upgrade the X64 WSS3.0 TO X64 SharePoint Foundation 2010.

Answer 3

This again, is one of those "WSS 3.0 to Foundation 2010 how to's" that skip 99% of the migration process and endlessly jabber about 1% of it. This only works 100% if the WSS 3.0 site you migrate is as empty as the Foundation 2010 site you just installed.

For just about everybody all "how to's", all Microsoft websites can be skipped because all the say is: attach the old content database to the new site.

BUT! What you really should do, is first check out all those webpart crap you're used to, because Foundation 2010 needs that installed first. Also, things you coded yourself, like a "cross site lookup" thing will break if you don't work out how to take that allong with you. You need to do al of planning and checking if you want a working website, without getting every unlisted error out there.

I've done a migration once and now have to do it twice. Incredible, what a nightmare.

Answer 4

As I posted in another thread, Robert Crane from CIAOPS is a Sharepoint guru and has posted a series of steps to migrate data from WSS3.0 to Sharepoint Foundation Server 2010 on his blog. I used them the other week to migrate 2 different clients to SFS2010. Worked flawlessly!

It's posted in 15 different sections so I'll give you the link to the last one that has all of his previous steps listed in order. Hope it helps you!

http://supportweb.ciaops.net.au/blog/archive/2010/11/21/migration-by-the-numbers-%E2%80%93-step-15.aspx

I know it says it's for SBS2008, but tbh, that doesn't matter. If you find something that is specific to SBS, ignore it and carry on.

As always, make sure you've got a backup/rollback plan in place before you start anything.

To provide a little more detail from some of your followup questions, you can access your SQL Express database through Management Studio Express quite easily. My boss posted how to access iton our blog a while back: http://www.grassrootsit.com.au/2011/blog/shrinking-sharepoint-wss-database-and-log-files/

Step 3 is probably the most relevant to your interests (although, I'd recommend making sure that your logfiles haven't bloated up too badly ;)).