on 2011 Sep 28 5:03 PM
I am converting all our databases from ASA 9.0.2.3508 to ASA 12.0.1.3152.
Running the unload wizard in Sybase Central work fine and generates the following command line.
dbunload -v -c "UID=dba;PWD=*******;DBF=C:\\databases\\asa12\\emr.db" -ac "UID=dba;PWD=***;DBF=C:\\databases\\asa12\\emr12_rebuild.db" -xx
Using the wizard, the process runs to completion with no errors.
When I attempt to run this manually, I get this error
***** SQL error: Unable to start specified database:
C:\\databases\\asa12\\emr12_rebuild.db was created by a different version of the software
I am prefixing the dbunload command with the correct path for ASA 12. I even tried running the command from the ASA12bin32 directory thinking that there may be some kind of pathing issue, but with no success and getting the same error.
The emr12_rebuild.db was created using the DBinit from ASA 12. We are manually creating the database ahead of time so that we can pre-allocate the space for the database and make the load faster (the datebases are all over 100 GB or larger) and not have the resulting db file be fragmented.
We would prefer to be able to this with a single batch file and not have to manually run the wizard as doing so exposes our passwords and we do not wish to do that.
Thanks
Alex
I guess the following quote from the DBUNLOAD utility doc does apply here - relöated to the -ac option:
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"
I suspect that without giving a server name, DBUNLOAD tries to load the new database on the engine it has started for the old database (which is the particular "Database Unload Support Engine" - dbunlspt.exe - a v9 database engine). And that will obviously fail for a new v10+ database.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Feel free to accept this answer...
Cf. this FAQ how to do so:)
User | Count |
---|---|
79 | |
10 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.