(the title says it all)

asked 01 Apr '10, 09:21

Breck%20Carter's gravatar image

Breck Carter
26.9k438609883
accept rate: 21%

edited 06 Aug '11, 17:33


The short answer is run the version 11 dbunload.exe utility on your version 5.5 database file.

The following Windows command script shows how to upgrade the version 5.5 sademo.db into a brand-new ddd11.db file.

There is often a lot more to upgrading across 6 major releases, but this is a starting point...

REM If you're a command-line kinda guy, here is my template Windows 
REM batch file run_dbunload_upgrade_v5_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 ddd11.db^
  -ap 4096^
  -c "DBF=sademo.db;UID=dba;PWD=sql"^
  -o dbunload_log_sademo.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 ddd11.db  new database to start

"%SQLANY11%\bin32\dbspawn.exe"^
  -f "%SQLANY11%\bin32\dbeng11.exe"^
  -o dbeng11_log_ddd11.txt^
  ddd11.db

PAUSE dbeng11 started...

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

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

PAUSE dbisql running...
permanent link

answered 01 Apr '10, 09:23

Breck%20Carter's gravatar image

Breck Carter
26.9k438609883
accept rate: 21%

Is this anything different from upgrading (aka rebuilding) a version 6 - 9 database? (Or are you preparing a Q&A for a current NG thread?)

(01 Apr '10, 10:12) Volker Barth

Actually, no, there is nothing different about the commands... and yes, it is a Q&A for a current newsgroup thread. However, the commands are just the starting point... upgrading from 5.5 is significantly different, the leap from 5.5 to 6 was quite large.

(01 Apr '10, 10:28) Breck Carter

@Breck: the leap from 5.5.04 to 6.0.0 was indeed large, we had trouble getting the charsets right (850 -> 1252). For one client we had to revert to 5.5, 6.0.0 GA was too early (but I'll stop babbling about old times).

(01 Apr '10, 11:48) Reimer Pods

I've ported this script over to Solaris and when I try to run it I get the following message:

* SQL error: Unable to start specified database: autostarting database failed

Any ideas on how to debug that to get a more specific error message?

(24 Nov '10, 22:54) Binh Ly
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:

×45
×19

question asked: 01 Apr '10, 09:21

question was seen: 1,220 times

last updated: 06 Aug '11, 17:33