on 06-19-2014 6:46 PM
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:
Command:
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).
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:
|
In the command you provided, add a ServerName parameter that differs from the file name for the v9 database.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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"
I did read the following in the documentation when going from v9 to v12+:
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.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.