Protect your database dump from unauthorized loads using the password parameter of the dump database command. You must then also include this password when you load the database.
See the Reference Manual: Commands.
Your password must be 6 – 30 characters long.
This example uses the password “bluesky” to protect the database dump of the pubs2 database:
dump database pubs2 to "/Syb_backup/mydb.db" with passwd = "bluesky"
This example loads the database dump using the same password:
load database pubs2 from "/Syb_backup/mydb.db" with passwd = "bluesky"
You can use the password-protected dump and load commands only with Adaptive Server version 12.5.2 and later. If you use the password parameter on a dump of a 12.5.2 version of Adaptive Server, the load fails if you try to load it on an earlier version of Adaptive Server.
You can load the dump only to another server that uses the same character set. For example, if you attempt to load a dump from a server that uses an ASCII character set to a server that uses a non-ASCII character set, the load fails because the value of the ASCII password is different from the non-ASCII password.
Passwords entered by users are converted to Adaptive Server local character set. Because ASCII characters generally have the same value representation across character sets, if a user’s password is in an ASCII character set, the passwords for dump and load are recognized across all character sets.
