Sybase 9 to Sybase 12 Unload problem

[Former Member]

I have a live sql anywhere 9 database (database9.db) that I have converted to sql anywhere 12 (database12.db) using sybase centrals wizard. It worked great. I have created a number of remote servers and tables with the new database as I'm merging multiple databases into one. After about a month of writing procedures I'm ready to unload the latest data from database9.db again with current data. I cannot seem to unload the data into an the newly created database, in any form structure and data, data only, etc. The error I get is "Password must be at least 6 characters". The password, sql123 for example works if I write to a new database, but not to the existing? Here is the command generated by sybase central. I have tried from a command prompt, with the password "sql123" in quotes to execute the unload, but i get the same error.

dbunload -v -c "UID=dba;PWD=;DBF=C:SCANNERHourlydatabase9.db" -ac "UID=dba;PWD=;DBF=C:Program FilesSQL Anywhere 12Bin64database12.db" -xx

I have 75 remote tables and a bunch of procedures i dont want to re-write. How can i get this database to unload into my existing database12.db.

[VolkerBarth]

Just to be sure:

Is the contents of the "v9 database to unload" and the v12 database disjunct - i.e. are there only different sets of database objects in both databases ? Otherwise, I don't know what happens if you unload, say a procedure into a database that has a procedure with that name and owner already...

[MCMartin]

What is the value of the option min_password_length in your version 12 database? A solution might be to temporarily change it to 0 for the unload.

[Former Member]

As you are going from a version 9 database to a version 12 database, it may be necessary to specify the database server name (Server) parameter in the -ac option.

For more information, please see dbunload utility

[Former Member]

The database9.db is currently not running while i perform the unload. I did however try to specify the server name of the existing database12.db where the database9.db would go. I got the same error.

dbunload -v -c "UID=dba;PWD=***;DBF=C:\\SCANNER\\Hourly\\database9.db" -ac "UID=dba;PWD=***;Server=10.0.0.64;DBN=database12.db;DBF=C:\\Program Files\\SQL Anywhere 12\\Bin64\\database12.db" -xx

Connecting and initializing
Unloading user and group definitions
Unloading table definitions
Unloading index definitions
Unloading functions
Unloading view definitions
Unloading procedures
Unloading triggers
Unloading SQL Remote definitions
Unloading MobiLink definitions
***** SQL error: Password must be at least 6 characters
An error occurred while attempting to unload the database 'C:\\SCANNER\\Hourly\\database9.db'.

Thank you for responding.

[VolkerBarth]

What happens if you use an unload with a reload.sql file? Can you apply that to the existing database?

IMHO, this would be the more controlled way to import data in an already existing, non-empty database...