Migrating from WSS 3.0 to Sharepoint 2010 Foundation

Hi Guys,

I've been asked to do a rather major upgrade to our WSS 3.0 server to get it up to scratch with the rest of our servers.

It will essentially be an upgrade from a Windows Server 2003 32bit server running SQL 2000 and Windows Sharepoint Services 3.0 on domain A to a server running Windows Server 2008 R2 64bit running SQL 2008 64bit and Sharepoint 2010 Foundation on domain B.

Server 1                        -> Server 2
Windows Server 2003 -> Windows Server 2008
32 bit                             -> 64 bit
SQL 2000                     -> SQL 2008
WSS 3.0                       -> Sharepoint 2010 Foundation.
domain A                      -> domain B

To make things more complicated, domain A is at site A and domain B is at site B.

I have been doing some research and it seems like the best path to take is to:

1. Upgrade the existing SQL server to SQL 2008
2. Add the Server 2008 64-bit machine with WSS 3.0 and SQL 2008 to the network and add to farm.
3. Backup and Migrate the Databases to the new machine
4. Point WSS to the new server
(I'm beginning to assume here....)
5. Move server to site B and change server domain to domain B
6. Upgrade WSS to SP 2010 inplace on the new machine
7. Remove old machine from farm.

Could somebody please let me know if I'm wasting my time with this due to excessive complications. I am an ambitious person but I don't want to spend more time on this then it would take to completely start from scratch (this site is only being used as a knowledge base).

Any help would be appreciated.  

Who is Participating?
Justin SmithConnect With a Mentor Sr. System EngineerCommented:
The approache you take will depend on the business requirements.  Assuming that an entire outage over a weekend is ok, and assuming you don't have any custom code/solutions, I would say....

1. Set up your Foundation server and SQL 2008 server.  Create the 2010 farm.
2. Create your web applications in the 2010 farm.  Deploy service apps.
3. Backup your WSS db's, copy them to the new SQL box, attach them in SQL.  This should upgrade the db's. (you may want to verify the upgrade path from 2000 to 2008).
4. In 2010 Central Admin, attach the db's to the corresponding web applicaiton.
5. Wait for the upgrade to complete by monitoring the Upgrade status page in Central Admin.
6. Test sites.  Finally, update your DNS to point to the new server.


-You may want to run the stsadm -o preupgrade check on the current WSS environment before upgrading
-Since you are going to a new domain, there could be extra steps to either migrate all user info in the current farm to their new accounts in the new domain.  Or, if there is a trust, you may need to tell your PeoplePicker in the 2010 farm about the new domain and the old domain so you can pick users from either to add to sites.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.