cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to dbunload v9 to v12

Former Member
0 Kudos

I recently inherited a .db file created on version 9 of SQLAnywhere. I'd like to upgrade it to v12 (or v16 if that's easier) so that I can run active queries against it on my development machine (no v9 available anymore). Have a really difficult time getting dbunload to run successfully, even following these instructions: http://dcx.sybase.com/index.html#1200/en/sachanges/unloading-reloading-upgrading-newjasper.html

Current Situation:

  • Have .db file created by v9 SQLAnywhere
  • installed v12 on local machine
  • Created blank v12 database to load data into

Command:

  • dbunload -c "UID=***;PWD=***;DBF=db_backup/*v9*.db" -ac "UID=DBA;PWD=sql;DBF=db/v12.db"
    - Error:
       - SQL Anywhere Unload Utility Version 12.0.1.4106
       - Connecting and initializing
       - ***** SQL error: Unable to start database server

Kinda stumped based on side testing (unload works against v12 database and simply running v12 database is fine). Any help would be greatly appreciated (apologies if this is a real noob question).

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

If the filename is the same for both databases, you'll need to make sure the autostarted server names differ.

It is recommended to specify a server name if you are rebuilding a v9 or earlier database when the target database is not already running:


If the original database was created using version 9 or earlier of SQL Anywhere and the new database is not already running, you must provide a database server name in the -ac option. For example:


dbunload -c "UID=DBA;PWD=sql;DBF=c:\mydata.db" -ac "UID=DBA;PWD=sql;DBF=c:\mynewdata.db;Server=newserver"

DocCommentXchange

In the command you provided, add a ServerName parameter that differs from the file name for the v9 database.

Former Member
0 Kudos

Thanks for quick response Tyson, unfortunately this command resulted in the same error:

dbunload -c "UID=***;PWD=***;DBF=db_backup/v9_backup.db" -ac "UID=DBA;PWD=sql;DBF=db/new.db;Server=newserver"

  • ***** SQL error: Unable to start database server

I did read the following in the documentation when going from v9 to v12+:

  • Do not unload a version 9 or earlier database when the database file requires recovery. When you use the Unload utility (dbunload) on a database file that requires recovery, a message is returned indicating that the database could not be started. Use a version 9 database server to start the database and then stop the database before retrying dbunload. To unload a version 9 or later database, you must be able to start the database in read-only mode. See -r database option.

It's possible my v9.db file was a result of a backup operation. Unfortunately I don't have the v9 running to do as the instructions say, "to start the database and then stop the database before retrying dbunload". Any idea where I can get the v9 install to complete this step? Thanks again.

Answers (0)