I have an old Database as archive for my pictures. The pictures are not stored in the database, only Chapter, pictureID and keywords. It is based on Sybase SQL Anywhere Database Engine Version 5.5.01 Build #1333. The application dose not offer to export listings. I would like to creat listings in a csv format or compareable. Or import the data to an open office database. In advance, thanks for help. If necessary I can upload the database (3.8MB)
p.s. I am not a specialist!!
Are you able to connect to your database using the SQL Anywhere 5 isql.exe utility?
Here is a sample command line:
"%SQLANY%\win32\isql.exe" -c "dbn=ddd5;eng=ddd5;uid=dba;pwd=sql"
On my Windows 7 computer, that is equivalent to this:
"C:\Program Files (x86)\Sybase\SQL Anywhere 5.0\win32\isql.exe" -c "dbn=ddd5;eng=ddd5;uid=dba;pwd=sql"
Then you can use the SELECT and OUTPUT command to create a CSV file. Here is an end-to-end demo with a new table called tt:
CREATE TABLE tt ( x integer, y integer ); insert tt values ( 1, 1 ); insert tt values ( 2, 2 ); commit; select * from tt; output to 'c:\temp\tt.txt';
Here is the output file:
If your database needs to be started before running isql.exe, here is a sample command for that:
answered 18 Dec '11, 10:04
As an option, you can unload a database from the command line. I used a demo database for my example, replace it with the actual database name.
c:\sqlany50\win32\dbsrv50.exe -c 10M -x tcpip c:\sqlany50\sademo.db
Create a directory to unload into.
Unload a database.
c:\sqlany50\win32\dbunload.exe -c "ENG=sademo;DBN=sademo;UID=dba;PWD=sql" c:\data\Unload -r c:\data\Sademo.sql
Ok. guys, this is exactly what I feared. You are the specialists and I have no clue. :-(( I really appreciate your immediate help.
Before I do or tell stupid things, I was trying to upload the "corpus delicti", so you can see, what I'm talking about. Unfortunately I'm not allowed to do that, as I have less than 100 reputation points.
Can I send the database to one of you and ask for transformation. For instance into an open office data base.
Just in case that there is a userID and PW necessary to access the data base, I wrote a mail to the company that has created this data base once. Just hoping they can tell me.
Thank you very much.
answered 20 Dec '11, 14:38