473,325 Members | 2,342 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Options to upgrade an SQL 6.5 DB to 2000

Hi All

I know that if SQL 6.5 was on a server and you then install SQL 2000 on it
you get the wizard option to upgrade an SQL 6.5 DB to 2000, but I don't have
the luxury of this.

I have an SQL 6.5 DB, which I want to convert, but only SQL 2000 on my
server.

Do you know what options I have available to me to perform this upgrade with
what I have? Are there any free external tools that can do this conversion
for me other than the switch wizard?

Thanks

Nov 23 '05 #1
4 2699
Hi

The Microsoft Upgrade Wizard is your only way of doing it.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mi**@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Laphan" <in**@SpamMeNot.co.uk> wrote in message
news:11*************@corp.supernews.com...
Hi All

I know that if SQL 6.5 was on a server and you then install SQL 2000 on it
you get the wizard option to upgrade an SQL 6.5 DB to 2000, but I don't
have
the luxury of this.

I have an SQL 6.5 DB, which I want to convert, but only SQL 2000 on my
server.

Do you know what options I have available to me to perform this upgrade
with
what I have? Are there any free external tools that can do this
conversion
for me other than the switch wizard?

Thanks

Nov 23 '05 #2
Laphan (in**@SpamMeNot.co.uk) writes:
I know that if SQL 6.5 was on a server and you then install SQL 2000 on
it you get the wizard option to upgrade an SQL 6.5 DB to 2000, but I
don't have the luxury of this.

I have an SQL 6.5 DB, which I want to convert, but only SQL 2000 on my
server.

Do you know what options I have available to me to perform this upgrade
with what I have? Are there any free external tools that can do this
conversion for me other than the switch wizard?


There is exactly one tool in this world that can read a 6.5 database,
and that's SQL Server 6.5.

If you have access to MSDN Subscriber Downloads, SQL 6.5 is available
there.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Nov 23 '05 #3
In message <Xn*********************@127.0.0.1>, Erland Sommarskog
<es****@sommarskog.se> writes
Laphan (in**@SpamMeNot.co.uk) writes:
I know that if SQL 6.5 was on a server and you then install SQL 2000 on
it you get the wizard option to upgrade an SQL 6.5 DB to 2000, but I
don't have the luxury of this.

I have an SQL 6.5 DB, which I want to convert, but only SQL 2000 on my
server.

Do you know what options I have available to me to perform this upgrade
with what I have? Are there any free external tools that can do this
conversion for me other than the switch wizard?


There is exactly one tool in this world that can read a 6.5 database,
and that's SQL Server 6.5.

If you have access to MSDN Subscriber Downloads, SQL 6.5 is available
there.


I recall upgrading a database from SQL Server 7 to 2000. All I did was
to copy the database file and attach it. I don't know whether the same
process would convert a version 6.5 file.

Make a copy of the database file(s) and try it.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author.

Nov 23 '05 #4
Bernard Peek (ba*@shrdlu.com) writes:
I recall upgrading a database from SQL Server 7 to 2000. All I did was
to copy the database file and attach it. I don't know whether the same
process would convert a version 6.5 file.

Make a copy of the database file(s) and try it.


No, that won't fly. As I said, there is only one application in this whole
wide world that knows how to read a 6.5 database, and that SQL 6.5.

6.5 had a completely different architecture from the current. In 6.5 there
were no database files. Instead you had device files. A device could
have portions from many databases, and a database could be on more than one
device. Log and data could be on different devices (which was recommended
for production databases), but could be on the same device (which was
fair enough for a development database). The whole device thing was overly
complex for NTFS, and was mainly designed for raw devices on Unix.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Nov 23 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: kg7poe | last post by:
We have Sqlsvr 6.5 under NT4. We want to upgrade the database to Sqlsvr 2000 under windows 2K. Is there any way we can do this by copying the database to the win2K computer?? At any rate would...
2
by: Saiyou Anh | last post by:
Hi! If doing online version upgrade from SQL 7.0 to SQl 2000, (1) do I need to shut down server? (2) after upgrading, is all login and db user, group information, scheduled Jobs, maintenance...
2
by: Matt | last post by:
Hello All I have SQL Server versions 6.5 and 2000 installed on a Windows 2000 server. I installed 6.5 first, coppied a backup of a database to the server and restored it. I then installed...
2
by: Trevor Hughes | last post by:
Hello All Our organisation has recently upgraded its operating system to Windows 2000. Prior to this I was running Access 2000 databases on NT machines using the Access 2000 Runtime with no...
2
by: DonLi | last post by:
Hi, I have a copy of Access 97 while my client uses Access 2000 which supports Unicode. My client has ordered a copy of Access 2000 upgrade for me, but the middleman, atomicpark.com is totally...
47
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...
1
by: rdraider | last post by:
Hi, I am trying to use the Upgrade Wizard in SQL 2000 to upgrade a SQL 6.5 db to 2000. I am only choosing to update a single database, not system objects. The Upgrade wizard connects to SQL 6.5,...
2
by: KR | last post by:
Hi, We are running a test upgrade form sql 2000 standard edition to sql 2005 developer edition. Followed through all the steps and specified the account(SA priveleges and currently used by the...
3
by: Mark D Powell | last post by:
I attempted to upgrade my SQL Server 2000 Enterprise Edition (32 bit) to SQL Severer 2005 EE 32 bit and while the prereqs passed the installer will not let me select the version 8.00.x (2000 SP4)...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.