Home Forums SQL Server 7,2000 Administration Help Needed - Need to load 6.5 database to 2000 RE: Help Needed - Need to load 6.5 database to 2000

  • 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.