Trying to extract data from ASA 8 db file

[former_SQLA_member1694994]

I have an ASA 8 db file that I want to extract data from using linux (with command line).

I didn't find ASA 8 driver for linux, so I tried running the following command to unload the db to a new ASA db file version, so I can extract data from it with the newer ASA version that I do have (version 17).

unfortunately I got this error:

Command:

dbunload -an new.db -c "dbf=old.db;uid=dba;pwd=sql"

Error:

SQL Anywhere Unload Utility Version 17.0.0.1063
Connecting and initializing
***** SQL error: Unable to start database server

I'm struggling with this problem for days, please help 🙂

[MarkCulp]

1) Did you source the asa_config.[c]sh file before running your command? I.e. Is dbeng8 in your path?

2) Try starting the engine (dbspawn dbeng8 old.db) prior to running dbunload and then use -c "dbn=old;uid=dba;pwd=sql" as your connection string.

[former_SQLA_member1694994]

I already ran sa_config.sh but I cannot find dbeng8, where can I find it for linux?

[Breck_Carter]

The dbunload utility should be able to read the ASA 8 database without starting a separate dbeng8 server... at least that's the way it works on Windows.

You may be able to convert the following Windows command file to Linux. It upgrades the ASA 8 demo database to SQL Anywhere 17:

REM If you're a command-line kinda guy, here is my template Windows 
REM batch file run_dbunload_upgrade_v8_to_v17.bat. It does the 
REM unload-reload-all-in-one-dbunload-step, then starts dbeng17 
REM and dbisql so you can make sure the new database is up and running.

REM Be sure to stop *all* database engines on the computer you're using, 
REM before starting the upgrade.

REM dbunload...
REM -an ...  where to put new database
REM -ap ...  new database page size
REM -c ...   old database startup connection string
REM -o ...   where to put unload console display text file
REM -v       verbose mode for console display

PAUSE MAKE SURE YOU DO NOT HAVE ANY ENGINES RUNNING.

"%SQLANY17%\\bin64\\dbunload.exe"^
  -an asademo17.db^
  -ap 4096^
  -c "DBF=C:\\Program Files (x86)\\Sybase\\SQL Anywhere 8\\asademo.db;UID=dba;PWD=sql"^
  -o dbunload_log_asademo.txt^
  -v

PAUSE dbunload/reload done...

"%SQLANY17%\\bin64\\dbspawn.exe"^
  -f "%SQLANY17%\\bin64\\dbeng17.exe"^
  -o dbeng17_log_ddd17.txt^
  asademo17.db 

PAUSE dbeng17 started...

"%SQLANY17%\\bin64\\dbisql.exe"^
  -c "ENG=asademo17;DBN=asademo17;UID=dba;PWD=sql" 

PAUSE dbisql running...

[former_SQLA_member1694994]

On our windows machine we have a ASA 16 and we have tried to use the unload wizard but It did not work also we could not find dbunload.exe to test your script in the installation dir

[VolkerBarth]

The database utilities like dbunload should reside in the same subdirectory of the SA install as the database engine, namely bin32 or bin64. Could it be your installation is incomplete or has left out some components incidentally?