Hello,

I am new to Sybase. I apologize for stating any wrong technical terms mentioned in this post. I have been given a database file "export.db" taken from Sybase Anywhere 7. Can anyone please let me know, is there a way to extract the data from the ".db" database file? Or is there any UI client available to pull the table data from the ".db" database files?

Thanks

Saravanakumar

asked 08 Apr '15, 10:31

Saravanakumar's gravatar image

Saravanakumar
1111
accept rate: 0%

edited 08 Apr '15, 10:32


If you have never used SQL Anywhere before you will need to understand you need a running server and account login information to access the tables contained inside of any database file.

Since you seem to know about Sybase Central I will assume you have a copy of the version 7 SQL Anywhere software but if you do not you will need to obtain that.

A full unload of the database can be obtained using the dbunload utility (dbunload.exe on Windows).

Any one table can be unloaded using the 'unload table' statement (if using any query tool, dbisql or dbisqlc come with the full product). From Sybase Central, you can unload any single table, one at a time, by navigating to the table list and right-mouse clicking to bring up an properties/attribute menu and selecting "Unload Data ..." the table from there.

If your version dbisql.exe has a Data menu you may also have an export function under that.

Unfortunately version 7 of SQL Anywhere went past support over a decade ago (~2002) and I do not have a running copy of it handy nor are there any web accessible copies of the help documentation that came with that version ... so you may need to refer to the docs that install with the software.

HTH

permanent link

answered 08 Apr '15, 11:45

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
6.5k2895
accept rate: 29%

edited 08 Apr '15, 11:46

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×98

question asked: 08 Apr '15, 10:31

question was seen: 536 times

last updated: 08 Apr '15, 11:46