|
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. |
|
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 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.
(18 Jul '11, 16:22)
jdilla5
Replies hidden
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...
(19 Jul '11, 08:32)
Volker Barth
|
|
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. |
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...