I have two databases created in SQL Anywhere v9. I cannot find a way to migrate them so that SQL Anywhere v11 will open them.

HELP!

asked 20 Nov '10, 23:57

Olan%20Knight's gravatar image

Olan Knight
29112
accept rate: 0%

edited 25 Nov '10, 09:04

Breck%20Carter's gravatar image

Breck Carter
26.2k430598862


You can use Sybase Central, or if you're like me, you prefer a command line approach using a script file for various reasons (like the ability to run it repeatedly without having to click-and-clack-and-make-mistakes).

This topic in the Help describes both techniques.

The following example uses the one-step dbunload -an utility on the Version 9 demo database. Just save it as a *.bat file, edit it for your database filespec, and run it...

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

"%SQLANY11%\bin32\dbunload.exe"^
  -an "C:\temp\demo11.db"^
  -ap 4096^
  -c "DBF=C:\Program Files\Sybase\SQL Anywhere 9\asademo.db;UID=dba;PWD=sql"^
  -o "C:\temp\dbunload_log_demo.txt"^
  -v

PAUSE dbunload/reload done...

REM dbeng11...
REM -c ...     initial RAM cache size
REM -o ...     where to put server console display text file
REM -os ...    when to rename and restart server console display text file
REM demo11.db  new database to start

"%SQLANY11%\bin32\dbspawn.exe"^
  -f "%SQLANY11%\bin32\dbeng11.exe"^
  -o "C:\temp\dbeng11_log_demo11.txt"^
  "C:\temp\demo11.db"

PAUSE dbeng11 started...

REM dbisql...
REM -c ...  new database connection string

"%SQLANY11%\bin32\dbisql.com"^
  -c "ENG=demo11;DBN=demo11;UID=dba;PWD=sql"

PAUSE All done...
permanent link

answered 21 Nov '10, 10:48

Breck%20Carter's gravatar image

Breck Carter
26.2k430598862
accept rate: 20%

edited 21 Nov '10, 10:59

Olan, further tips can be found on this question.

permanent link

answered 21 Nov '10, 11:17

Volker%20Barth's gravatar image

Volker Barth
30.8k308456665
accept rate: 32%

edited 22 Nov '10, 08:25

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:

×137
×99
×45
×39

question asked: 20 Nov '10, 23:57

question was seen: 1,578 times

last updated: 25 Nov '10, 09:04