Open SQL 6.5 .DAT file in SQL 2000

Hi,

I have a .dat file from SQL 6.5 server, and I need to somehow attach the database to my SQL 2000 server to open it.  I do not have an instance of SQL 6.5 running anywhere anymore.  (This is an old database.)  Is there any way I can open this .dat file?  Is it possible to import it somehow?  Thank you for your assistance.

Deanna
dpozegaAsked:
Who is Participating?
 
alanblockleyCommented:
Load the data into an MS SQL server 7 (or 6.5) server (how you choose to do this is up to you).

Then from Enterprise manager you need to right click on the database you want, click on "Export" and export to your SQL 2000 server.  This will import all the tables, views, etc for you.  Incidently, you can export any MS SQL database this way to any db engine, as long as you have an odbc driver for it.  (Tested with MSSQL, MySQL, firebird and interbase).

Hope this helps.

Alan
0
 
ispalenyCommented:
6.5 files are not supported in 2000. You need 7.0 or 6.5 version
0
 
ispalenyCommented:
7.0 engine is built in MSDE 1.0
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
dpozegaAuthor Commented:
Does that mean it's impossible to do anything with the .dat file I have?  Is there any way I can extract data from it?  Even importing the entire file into Access or something?
0
 
dpozegaAuthor Commented:
Thank you both.

Alan,  can I export directly from SQL Server V6.5 to a SQL Server 2000 database as long as I have the ODBC connection?

Thanks,
Deanna
0
 
alanblockleyCommented:
You should be able to.  ODBC was created to help with inter-database connectivity.

Alan
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.