Post reply

Help Needed - Need to load 6.5 database to 2000

  • August 6, 2003 at 7:50 am

    #58718

    Hi All,

    I needed to load one SQL Server 6.5 database into SQL Server 2000.

    Also can we have SQL Server 6.5, 7.0 and SQL Server 2000 on the same machine?!

    Please Help!!!

    Thanks In Advance.

    .

  • August 6, 2003 at 7:58 am

    #468831

    Hi mdamera,

    quote:

    I needed to load one SQL Server 6.5 database into SQL Server 2000.

    as far as I know, you need to upgrade first to SQL 7 and then SQL2k

    quote:

    Also can we have SQL Server 6.5, 7.0 and SQL Server 2000 on the same machine?!

    SQL7 and SQL2k no problem. No experience with SQL6.5

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • August 6, 2003 at 8:07 am

    #468834

    quote:

    I needed to load one SQL Server 6.5 database into SQL Server 2000.

    You have to perform upgrade from SQL Server 6.5 to 2000.

    quote:

    Also can we have SQL Server 6.5, 7.0 and SQL Server 2000 on the same machine?!

    If you have SQL Server version 6.5 installed, you can keep the SQL Server version 6.5 installation and also install a default or named instance of SQL Server 2000, Version switching can be used to move between SQL Server version 6.5 and SQL Server 2000. You can run either the default instance of SQL Server 2000 or the instance of SQL Server 6.5, but not both at the same time.

    You can keep an installation of SQL Server version 7.0 as default instance on your computer and also install a named instance of SQL Server 2000 on the same computer. Both Versions can be run at same time.

    In order to run 6.5, 7.0 and 2000 in same machine, you have to install 6.5 first, 7.0 as default instance and 2000 as named instance. And switch 6.5 and 7.0 with version switch. Version 6.5 and 7.0 can't be run at same time too.

  • August 6, 2003 at 8:10 am

    #468837

    Thank You Allen. I would uninstall SQL Server 2000 from this machine now (I just installed this morning), then install SQL Server 6.5 (as named instance), then SQL Server 2000 (default). Is that the process?!

    .

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply