This is my definitive guide on migrating from 32 bit Windows SharePoint Services 3 to SharePoint Foundation 2010 (64 bit only, oof!). It’s not quite as definitive as I would like as I barely had time to work this through once, let alone multiple times:
- I changed the user account that runs WSS3 from ‘NETWORK SERVICE’ to a domain account (though I’m unsure if this step is required). I originally did this when trying to restore the 32bit WSS3 onto the 64bit box and then using 64bit WSS3 to try and upgrade it. Don’t do that by the way. Anyway it made working with the database easier on the whole anyway.
- Backed up the SharePoint content database, called STS_servername_1 in my case. (This server used the ‘Windows Internal Database’, an extra crippled version of the already crippled SQL express. I had installed the SQL 2005 tools on there for a different project so I used the ‘SQL Server Configuration Manager’ to change the service argument to add “;-T7806” and I then used the SQL management studio to do the backup).
- Installed 64bit Sql Server 2008 express on the new 64 bit server (I named the main instance the same as the instance on the 32bit box, not sure if that matters)
- Installed SharePoint Foundation on the new 64 bit server (it automatically set itself up in the SQL instance I installed).
- Restored the content database to the new server (again, using the management studio; I know that it can be done through the command prompt but I like the visual feedback).
- Within the Central Administration site on the new server I went to ‘Manage Content Databases’, clicked on the preinstalled content database and removed it in the subsequent interface. This step removes the content linked to ‘/’ so that the restored database can go there.
- Added the restored database to the farm using stsadm. (in our case: stsadm -o addcontentdb -databasename STS_servername_1 -databaseserver newserver-url http://newserver/)
- Upgraded the content database using the ‘upgrade-spcontentdatabase’ command within the Sharepoint PowerShell.
- The content should now show up when you pull up http://newserver/ , but to complete the upgrade (and keep the content database from showing as ‘mostly upgraded’ or something along those lines) I had to upgrade the view under ‘Site Settings’ within the Sharepoint site and then going to (I believe) ‘Visual Upgrade’.
Obviously our setup is fairly simple with one server driving the whole ‘stack’. Our content is also fairly static (it didn’t matter that the database backup that I was working with was a day old). Your results, of course, may vary (but will probably do a sight better than trying to put something together from the amalgamation of websites that only convey one piece of the puzzle!).