Migrating from WSS 3.0 to Sharepoint 2010 Foundation

Posted on 2011-04-27
Last Modified: 2012-05-11
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.  

Question by:lemonville
    LVL 38

    Accepted Solution

    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.
    LVL 38

    Assisted Solution


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now