If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Sybase > Converting Sybase Database

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-17-11, 09:13
ccc_ict ccc_ict is offline
Registered User
 
Join Date: Jun 2011
Posts: 1
Question Converting Sybase Database

We have a sybase database file, extension .db. The application has been decomissioned (a long time ago) and the users need the data urgently. We would like to convert the tables into spreadsheets (Excel) or CSV files, etc. Basically extract the data from the tables.

The database file is a physical file .db and we are at a loss of how to open & read this file and see the tables & data. Are there any utilities that will do this. The only thing we have found requires us to connect to a database service but as you can imagine, there is no service. Only a physical .db file.

Any help is very much appreciated.

Thanks
Reply With Quote
  #2 (permalink)  
Old 06-17-11, 14:21
mike_bike_kite mike_bike_kite is offline
vaguely human
 
Join Date: Jun 2007
Location: London
Posts: 2,519
I think you'll just have to install a free version of Sybase. Use that to open the file and then use the bcp utility to extract the data from each useful table in a format compatible with excel.
__________________
Mike
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On