Skip to Content
avatar image
Former Member

Upgrading SQL Anywhere DB Previous to v9

Have a DB and LOG pair from some version previous to v9, so SQLAnywhere v16 can't unload or upgrad.

I don't own a version of SQLAny previous to v9.

What to do...especially if I don't have an active S id?

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 03, 2017 at 08:37 PM

    Thank you both.

    I ended up using Sybase Central 12's gui to unload.

    I then created a new db using SQLAnywhere 16's gui and ran/loaded the SQL output from the unload.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 14, 2016 at 12:44 PM

    The SQL Anywhere 16 dbunload.exe utility can indeed to an unload-and-reload-in-place. Here is a sample Windows command file for upgrading a v5.5 database file...

    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...
    
    
    
    Add comment
    10|10000 characters needed characters exceeded

  • Nov 14, 2016 at 01:45 AM

    Hi John,

    Can you confirm the following document?

    The rebuild process for version 9 and earlier databases
    http://dcx.sap.com/index.html#sa160/en/sachanges/unloading-reloading-upgrading-newjasper.html

    Thanks,
    Atsushi

    Add comment
    10|10000 characters needed characters exceeded

    • I was able to rebuild version 9 databases by version 16 in the following procedures.

      1.Click Start » Programs » SQL Anywhere 16 » Administration Tools » Sybase Central.
      2.Click Tools » SQL Anywhere 16 » Unload Database.
      3.Read the introductory page of the Unload Database Wizard, and click Next.
      4.Click Unload a database running on an earlier version of the server, or a database that is not running. Specify the connection information for the database. Click Next.
      5.Click Unload and reload into a new database. Click Next.
      6.Specify a new file name for the database. Click Next.
      7.Choose to unload structure and data. Click Next.
      8.Specify whether you want to connect to the new database when the rebuild is complete.
      9.Click Finish. Examine the new database to confirm that the rebuild completed properly.

      Thanks,
      Atsushi