Skip to Content
0
Former Member
Jun 19, 2014 at 05:46 PM

Unable to dbunload v9 to v12

106 Views

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).