SEO

#1 (**permalink**) 02-29-2008, 01:55 PM

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

#2 (**permalink**) 02-29-2008, 01:55 PM

Hi

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

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

IM: mike@epprecht.net

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

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

"Laphan" <info@SpamMeNot.co.uk> wrote in message
news:11njslucd640680@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
>
>
>

#3 (**permalink**) 02-29-2008, 01:55 PM

Laphan (info@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, esquel@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

#4 (**permalink**) 02-29-2008, 01:55 PM

In message <Xns97101041BF43Yazorman@127.0.0.1>, Erland Sommarskog
<esquel@sommarskog.se> writes
>Laphan (info@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.

#5 (**permalink**) 02-29-2008, 01:55 PM

Bernard Peek (bap@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, esquel@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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Options to upgrade an SQL 6.5 DB to 2000