Posted by Erland Sommarskog on 11/16/05 14:28

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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]