The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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

asked 18 Apr '15, 07:03

vertigo's gravatar image

vertigo
111
accept rate: 0%


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...
permanent link

answered 18 Apr '15, 14:26

Breck%20Carter's gravatar image

Breck Carter
26.6k418576824
accept rate: 21%

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:

×97

question asked: 18 Apr '15, 07:03

question was seen: 281 times

last updated: 18 Apr '15, 14:26