Restore Question - 6.5 to 7.0 1

[tccraig]

I have a backup from SQL Server 6.5 (a DAT file). Is it possible to restore that backup on a SQL Server 7.0 or 2000. I no longer have 6.5 installed.

 

[hencyt]

Did you find a solution to this? I have the same issue. We have a 6.5 db on 5 cd's that I need to restore on 7.0 or, even better SQL 2000. We no longer have 6.5 installed anywhere and would like to avoid building a server to install it on, if possible.

Did you try this? Did you have any issues?

Thanks in advance,
Sunny

 

[JayKusch]

You cannot "directly" restore a 6.5 DB to 7.0. You can install 6.5 then convert to 7 or you can install 6.5 and DTS to a 7.0 DB. Here is a link to look at ...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;195444

Thanks

J. Kusch

 

[JayKusch]

This also applies for SQL Server 2000 by the way.

Thanks

J. Kusch

 

[tccraig]

I think the problem is that neither of us still have SQL Server 6.5 installed anywhere on our network nor do we have access to the installation cds. All we have is a backup of the data from 6.5. We are requesting assistance/advice on getting that data to a restorable/readable format.

Thanks,
Terry

 

[nigelrivett]

Don't think it is possible without a v6.5 installation.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[JayKusch]

No ... you will need a copy of 6.5 to proceed

Thanks

J. Kusch

 

[tccraig]

Does Microsoft still offer SQL Server 6.5 or is there an alternate (legal) supplier?