sa 17 : after dbunload new_db password for logging into the new database is not the same as before

[ximen]

I used sa17
dbunload -v -c "UID=dba;PWD=sql;Server=c5;ASTART=No" -an "D:\t.db" -ap 4096 -ea None -kdi 0 -ii -g -up -t "DBA.A_dmbom"
A new database has been generated, but why is the database password incorrect? How can we find the password for this database

[chris_keating]

Unloading a database with -e (exclude tables) or -t does not include database schema users, views, and procedures. As a result, the unload cannot be used for rebuilding a database.

[ximen]

I understand. Now I have a new question, when dbunload data, can views and procedures be imported into the new database together? How should modify my parameters? thanks

[chris_keating]

Perhaps you can share a little more about your requirement? You can do a schema only unload ( dbunload -n ... ) and then separately a table only unload (to a file). I have different recommendations depending on the number of tables that are to be unloaded/reloaded.