older SQL Anywhere version (up to 9).

[Former Member]

hi

can someone share a link for old software of SQL Anywhere.

i try to open db file that when i open it in notepad i see: WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp.

moshe

[Breck_Carter]

You can upgrade the database file using the Developers Edition of SQL Anywhere 16.

REM If you're a command-line kinda guy, here is my template Windows 
REM batch file run_dbunload_upgrade_v5_to_v16.bat. It does the 
REM unload-reload-all-in-one-dbunload-step, then starts dbeng16 
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.

"%SQLANY16%\\bin64\\dbunload.exe"^
  -an ddd16.db^
  -ap 4096^
  -c "DBF=sademo.db;UID=dba;PWD=sql"^
  -o dbunload_log_sademo.txt^
  -v

PAUSE dbunload/reload done...

"%SQLANY16%\\bin64\\dbspawn.exe"^
  -f "%SQLANY16%\\bin64\\dbeng16.exe"^
  -o dbeng16_log_ddd16.txt^
  ddd16.db 

PAUSE dbeng16 started...

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

PAUSE dbisql running...