Try OpenEdge Now
skip to main content
Database Administration
Protecting Your Data : Transparent Data Encryption : Running with Transparent Data Encryption enabled : Binary dump and load of data
 
Binary dump and load of data
By default, the contents of binary dump and audit archive files are not encrypted, even if the database objects being dumped or archived are encrypted. You can optionally add encryption via passphrase-based encryption to your binary dump and audit archive files to increase security of the dump and archive files. As long as your database is enabled for encryption, you can encrypt your binary dump or audit archive, even if the tables you are dumping are not encrypted.
To encrypt the output of binary dump or audit archive, add the following case-sensitive qualifier to the command line:
-Cipher 6
You will be prompted to enter and verify a passphrase. This passphrase is unique to this dump file. If you forget the passphrase, there is no way to recover the contents of the dump file.
When you load your data, you must add -Cipher 6 to the command line to indicate that you are loading encrypted data. You will be prompted to enter and verify the passphrase that you entered when you created the dump.
If you choose to dump or archive encrypted data into an unencrypted dump or archive file, you should load the dump or archive file and delete it as soon as possible to minimize the time the data is stored in an unencrypted format.