Sharepoint Windows Internal Database migration to SQL

Posted on 2012-09-07
Last Modified: 2012-09-24
We currently have a Sharepoint version 3.0 instance running on a server 2003 box. We are looking to migrate this instance to a 2008 box running Sharepoint 2010.

At present the database is running a local Windows Internal Database which I understand needs to be transfered to an SQL instance for it to be moved

Is there a step by step guide on how to get this instance off the 2003 box and onto a 2008 box running 2010.

Can this be done ?
Question by:L-Plate
    LVL 38

    Accepted Solution

    Yes it can be done.  You treat it like any other upgrade from SP 2007 to SP 2010.

    You will be doing the "database attach" method of the upgrade.  In short, it means you will be copying your databases to the 2010 server, attaching them in SQL, then attaching them to web applications in 2010.  Rather than listing steps, it's easier to read it straight from Microsoft.  There are things that need to happen first, like getting your WSS 3.0 on at least SP2.  Would also help to run the stsadm -o preupgradecheck on 3.0 too, before migrating.
    LVL 2

    Assisted Solution

    Looks like your requirement is to upgrade WSS 3.0 to Sharepoint 2010. If you choose to go with in-place upgrade, we need to first migrate to Microsoft Sharepoint Foundation 2010 and then to Sharepoint Server 2010.

    However if you choose to go with Database attach upgrade approach, then this allows you to attach and upgrade the content databases from Windows SharePoint Services 3.0 to SharePoint Server 2010. This process upgrades the data in the content databases, but does not transfer any farm settings.

    Please refer the link that gives a clear insight of the approach strategy that suits your need.

    Shailendra Karve

    Author Closing Comment

    Great, thanks guys !

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    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…
    This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
    Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…

    737 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

    20 Experts available now in Live!

    Get 1:1 Help Now