The forum will be down for scheduled maintenance on Saturday, March 4 beginning at 10am EST. Actual downtime is unknown but may be several hours.

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.8k421580826
accept rate: 20%

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: 18 Apr '15, 07:03

question was seen: 292 times

last updated: 18 Apr '15, 14:26