I am converting all our databases from ASA 126.96.36.19908 to ASA 188.8.131.5252.
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
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.
I guess the following quote from the DBUNLOAD utility doc does apply here - relöated to the -ac option:
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.
answered 29 Sep '11, 03:28