I’m trying to upgrade a 9.0.2 SQL Anywhere db to 10.0.1 on Win XP and I’m having trouble. I try using the unload/reload wizard in Sybase Central 10 and I get this output:
dbunload -v -c “UID=dba;PWD=***;DBF=C:\Servoy\Servoy 3.1\database\smart_trash.db” -an “C:\Servoy\Servoy 3.5.x\database\smart_trash.db” -ap 4096 -ea None -ii -sa -so _sc284916506
Connecting and initializing
***** SQL error: Unable to start database server
The database ‘C:\Servoy\Servoy 3.1\database\smart_trash.db’ could not be unloaded.
The database ‘C:\Servoy\Servoy 3.1\database\smart_trash.db’ could not be unloaded.
I have tried it with both the 10.0.1 server up and the 9.0.2 server up and also with neither of them up. Always the same result. I AM able to connect to the db from Sybase Central, so the db is sound and I have the right username/password.
I’m trying to upgrade a 9.0.2 SQL Anywhere db to 10.0.1 on Win XP and I’m having trouble. I try using the unload/reload wizard in Sybase Central 10 and I get this output:
dbunload -v -c “UID=dba;PWD=***;DBF=C:\Servoy\Servoy 3.1\database\smart_trash.db” -an “C:\Servoy\Servoy 3.5.x\database\smart_trash.db” -ap 4096 -ea None -ii -sa -so _sc284916506
Connecting and initializing
***** SQL error: Unable to start database server
The database ‘C:\Servoy\Servoy 3.1\database\smart_trash.db’ could not be unloaded.
The database ‘C:\Servoy\Servoy 3.1\database\smart_trash.db’ could not be unloaded.
I have tried it with both the 10.0.1 server up and the 9.0.2 server up and also with neither of them up. Always the same result. I AM able to connect to the db from Sybase Central, so the db is sound and I have the right username/password.
What am I doing wrong? Thanks for your help.
The first thing to do is to determine whether the problem is due to the database server not starting. One way to troubleshoot is to break apart the dbunload process into two steps:
Start the database with dbeng10.exe. In your case, the command line would read “dbeng10.exe C:\Servoy\Servoy 3.1\database\smart_trash.db”.
Next you can run the dbunload command, but this time specify the server name in the connection string instead of the db file location. The connection string would read “UID=dba;PWD=***;eng=smart_trash.db”.
This should get dbunload running OK. Any further problems may indicate an issue with dbunload, at which point I’d be happy to provide further help. Just PM me and we can discuss, as it is likely that we would need you to send us the database (if possible).
Step one in the instructions above do not make sense. If smart_trash.db is a 9.0.2 database, how can you, “Start the database with dbeng10.exe” ?
One would get an error.
I’m getting the same error Adrian received when trying to use dbunload.exe to take my 9.0.2 database to iAnywhere 11. It has worked perfectly with five other databases, including one that is almost 4.5 gigs. It’s my servoy_repository that will not unload. I have tried all kinds of things, like trying to take it to iAnywhere 10 to no avail.