Help Needed - Need to load 6.5 database to 2000

Question

Post reply

Help Needed - Need to load 6.5 database to 2000

mybid2003

SSCertifiable

Points: 6620
More actions
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.
.

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

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

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

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]

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 2

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.

mybid2003 SSCertifiable Points: 6620 More actions · Answer 3

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?!

.