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.
asked 18 Jul '11, 14:45
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.
answered 19 Jul '11, 06:38