Getting data out of Sql Datbases

Posted on 2007-10-11
Last Modified: 2010-03-19
I tried to upgrade from WSS 2.0 to WSS 3.0 and the program crashed in the middle of the operation.

I have all of the content database files (mdf and ldf) from the 2.0 installation still available to me.

I uninstalled WSS 2.0, installed WSS 3.0 and made new sites.   Now, I need to get the document libraries from the old databases and put them in the new sites.  

My server is running WSS 3.0 on Windows Server 2003.
Question by:richfore
    LVL 18

    Expert Comment

    and your exact question is ... ?

    Author Comment

    My question was 'how do I get my document libraries out of the 2.0 databases?'


    LVL 18

    Expert Comment

    sorry, never took a close look to those databases. And the bad part is, they probably are changed during upgrade, so using the old databases in the new installation is more than likely not going to work ...
    LVL 42

    Accepted Solution

    there is no direct way to do this... you can't take content backup from 2.0 and restore it to 3.0.

    however, if you have a backup of your 2.0 site, you could install wss 2.0 on another server, restore your 2.0 content, and then export out your lists and documents...  then import them into your 3.0 site.  a bit of a manual process, but it is the only way to do it unless you actually go through the upgrade installation process that converts your 2.0 database to 3.0.

    if you want to do the manual export method, use stsadm for restoring your content to the temp 2.0 installation.

    Author Comment

    Thanks everyone..

    Zephyr hex...  I am going to do just that..  Thanks so much!

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    728 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

    19 Experts available now in Live!

    Get 1:1 Help Now