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

jdilla5's gravatar image

jdilla5
31234
accept rate: 0%

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...

(19 Jul '11, 08:35) Volker Barth

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

permanent link

answered 18 Jul '11, 15:48

Elmi%20Eflov's gravatar image

Elmi Eflov
7811014
accept rate: 31%

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.

permanent link

answered 19 Jul '11, 06:38

Martin's gravatar image

Martin
8.6k118151237
accept rate: 14%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×39

question asked: 18 Jul '11, 14:45

question was seen: 2,083 times

last updated: 19 Jul '11, 08:35