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
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:
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)
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.
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.
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 ;)).