SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Other Forums
 SQL Server 6.5 \ SQL Server 7.0
 Read an exported 6.5 database
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

tmccar
Starting Member

Ireland
27 Posts

Posted - 08/29/2011 :  16:13:56  Show Profile  Reply with Quote
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

USA
37296 Posts

Posted - 08/29/2011 :  16:17:52  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

Edited by - tkizer on 09/13/2012 18:49:03
Go to Top of Page

tmccar
Starting Member

Ireland
27 Posts

Posted - 08/30/2011 :  04:22:25  Show Profile  Reply with Quote
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

United Kingdom
22431 Posts

Posted - 08/30/2011 :  04:27:46  Show Profile  Reply with Quote
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)

Edited by - Kristen on 08/30/2011 07:13:40
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30281 Posts

Posted - 08/30/2011 :  04:51:23  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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

United Kingdom
22431 Posts

Posted - 08/30/2011 :  07:13:54  Show Profile  Reply with Quote
Thanks Peso
Go to Top of Page

tmccar
Starting Member

Ireland
27 Posts

Posted - 08/30/2011 :  07:47:13  Show Profile  Reply with Quote
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

Sweden
30281 Posts

Posted - 08/30/2011 :  07:50:58  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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

United Kingdom
22431 Posts

Posted - 08/30/2011 :  08:04:51  Show Profile  Reply with Quote
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

Ireland
27 Posts

Posted - 08/30/2011 :  08:41:11  Show Profile  Reply with Quote
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

United Kingdom
22431 Posts

Posted - 08/30/2011 :  08:55:04  Show Profile  Reply with Quote
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

Ireland
27 Posts

Posted - 08/30/2011 :  11:14:57  Show Profile  Reply with Quote
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

Sweden
30281 Posts

Posted - 09/05/2011 :  02:31:29  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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

Ireland
27 Posts

Posted - 09/05/2011 :  04:08:02  Show Profile  Reply with Quote
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

USA
37296 Posts

Posted - 09/05/2011 :  12:01:55  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

United Kingdom
22431 Posts

Posted - 09/05/2011 :  12:23:27  Show Profile  Reply with Quote
No mistress?
Go to Top of Page

Transact Charlie
Flowing Fount of Yak Knowledge

United Kingdom
3451 Posts

Posted - 09/05/2011 :  16:58:56  Show Profile  Visit Transact Charlie's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
3451 Posts

Posted - 09/05/2011 :  16:59:22  Show Profile  Visit Transact Charlie's Homepage  Reply with Quote
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

Sweden
30281 Posts

Posted - 09/05/2011 :  23:38:29  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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

Sweden
30281 Posts

Posted - 09/05/2011 :  23:41:52  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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

United Kingdom
22431 Posts

Posted - 09/06/2011 :  08:34:01  Show Profile  Reply with Quote
"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
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000