Upgrade SQL 6.5 to SQL 2000

Posted on 2006-05-11
Last Modified: 2007-12-19
I have an old SQL 6.5 database that is still in use, and we want to upgrade it to SQL 2000.  I was planning to test it using the Upgrade Wizard, but wondered if after I did this would the SQL 6.5 database be available to the user?  I just want to test the upgrade and application first.  

I'm planning to put it on a multi-use SQL 2000 server.  Are there any considerations I need to think about before I try the upgrade?  Unfortunately, my SQL 6.5 experience is very limited, so any recommendations are really appreciated.

Thanks !
Question by:BetsyV
    LVL 13

    Accepted Solution

    You do not want to upgrade during hours where the server will be used.

    If you want to test the upgrade, backup the database, move to a test server and upgrade from there.
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    > Are there any considerations I need to think about before I try the upgrade?
    Take a full back up of your database..
    Restore it on  different machine with SQL server 6.5, and then use the upgrade wizard in this machine. Then test your application,
    If you find that there is no problem, then either you can use the upgrade wizard on the other machine or make this machine the server
    LVL 3

    Expert Comment


    The following link will give you the complete information of upgrading SQL 6.5 to SQL 2000 with white paper documentation.
    It might take some time to go through it but its simple and well documented.

    Author Comment

    I'm sorry to be slow to get back to this question.  I was called away right after I submitted it, and have just arrived back.   I am accepting the first response because it pointed me in the right direction, and was the first back.  Again, I'm really sorry to leave it hanging for so long, and appreciate all the answers.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Viewers will learn how the fundamental information of how to create a table.

    754 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

    24 Experts available now in Live!

    Get 1:1 Help Now