Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 SQL Server 6.5 \ SQL Server 7.0
 Read an exported 6.5 database

Author  Topic 

tmccar
Starting Member

27 Posts

Posted - 2011-08-29 : 16:13:56
I have a database that was output from SQL Server 6.5 and it's a .DAT file. I would like (love) to be able to convert it to Excel, csv or some readable format.

Tom Mc Carrick

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-29 : 16:17:52
A dat file in SQL Server 6.5 is probably a backup file. You'll need to restore it into SQL Server 6.5. Once you've done that, you can easily export the data using bcp or other export tools.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

tmccar
Starting Member

27 Posts

Posted - 2011-08-30 : 04:22:25
quote:
Originally posted by tkizer

A dat file in SQL Server 6.5 is probably a backup file. You'll need to restore it into SQL Server 6.5, SQL Server 7.0 or SQL Server 2000. Once you've done that, you can easily export the data using bcp or other export tools.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog



OK, but I don't have either of those. What is my best course of action?

Tom Mc Carrick
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2011-08-30 : 04:27:46
You will probably be able to find a Trial version to install, and restore to. I'm pretty sure the "Express" version will do - which will run on a standalone PC.

If you use SQL 2000 (edit: With service pack 4 applied) you can THEN take a backup of the database which will restore under SQL 2005 or SQL 2008. (Note that if you use SQL7 you will be able to restore to SQL2005, but not SQL 2008)
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2011-08-30 : 04:51:23
And apply SP4 on SQL Server 2000 before making the second backup.



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2011-08-30 : 07:13:54
Thanks Peso
Go to Top of Page

tmccar
Starting Member

27 Posts

Posted - 2011-08-30 : 07:47:13
I don't think there will be a trial version of SQL server 2000 available at this stage.

Tom Mc Carrick
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2011-08-30 : 07:50:58
I have access to full msdn library so that won't be a problem.



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2011-08-30 : 08:04:51
quote:
Originally posted by tmccar

I don't think there will be a trial version of SQL server 2000 available at this stage.


MSDE (as I think it was called) abounded all over the place for developers to create stand-alone apps, so I doubt you'll have a problem finding one.

I very VERY much doubt there is any other route to reading a backup file (if that is what you have) from SQL 6.5.
Go to Top of Page

tmccar
Starting Member

27 Posts

Posted - 2011-08-30 : 08:41:11
quote:
Originally posted by Kristen

quote:
Originally posted by tmccar

I don't think there will be a trial version of SQL server 2000 available at this stage.


MSDE (as I think it was called) abounded all over the place for developers to create stand-alone apps, so I doubt you'll have a problem finding one.

I very VERY much doubt there is any other route to reading a backup file (if that is what you have) from SQL 6.5.



Wow - that's great.
So is a subsription to MSDN expensive, as a matter of interest?

Tom Mc Carrick
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2011-08-30 : 08:55:04
MSDN is quite expensive, but there are other Developer subscriptions which are very reasonable (I subscribe to "Action pack"). Depends what you need - MSDN [from memory, I let my MSDN subscription lapse some years ago] gets you every single platform that Microsoft produce.

There is also, separately, a SQL Developers license you can buy. That gets you the Enterprise Licence for a very modest amount - only restriction is that you cannot use it to deploy an application, so ideal for development.

Microsoft would like developers to build software without having to spend their life's savings on developer tools ... it is the applications that sell Computers and End User Licences of course ...
Go to Top of Page

tmccar
Starting Member

27 Posts

Posted - 2011-08-30 : 11:14:57
SwePeso has kindly agreed to restore this for me so I will wait and see how he gets on.

Tom Mc Carrick
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2011-09-05 : 02:31:29
Done. You can download the zipped text files from ftp now.


N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

tmccar
Starting Member

27 Posts

Posted - 2011-09-05 : 04:08:02
Many thanks Peter - I will let you know how I get on.

Tom

quote:
Originally posted by SwePeso

Done. You can download the zipped text files from ftp now.


N 56°04'39.26"
E 12°55'05.63"




Tom Mc Carrick
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-09-05 : 12:01:55
Peter, you are awesome. 4 kids, 1 wife, 1 house remodeled, how do you find the time?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2011-09-05 : 12:23:27
No mistress?
Go to Top of Page

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2011-09-05 : 16:58:56
SQL Server *is* his mistress.

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
Go to Top of Page

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2011-09-05 : 16:59:22
Actually. No.

SQL Server is his b**ch

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2011-09-05 : 23:38:29
I love you guys! You crack me up now and then...



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2011-09-05 : 23:41:52
quote:
Originally posted by tkizer

Peter, you are awesome. 4 kids, 1 wife, 1 house remodeled, how do you find the time?
Well, sometimes you need to go down the memory lane.
It was a painful insight to remember how everything was so awkward in SQL Server 6.5.


N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2011-09-06 : 08:34:01
"It was a painful insight to remember how everything was so awkward in SQL Server 6.5"

Ain't that the truth!

08/30/2011 : 11:14:57 "SwePeso has kindly agreed to restore this for me so I will wait and see how he gets on."
09/05/2011 : 02:31:29 "Done. You can download the zipped text files from ftp now."
Go to Top of Page
  Previous Page&nsp;  Next Page

- Advertisement -