You can create an encrypted copy of a database by using the CREATE ENCRYPTED DATABASE statement. This statement creates a copy of the file (in this case, in encrypted form), and does not overwrite the original database file.
By default, you must have the SERVER OPERATOR system privilege to execute the CREATE ENCRYPTED DATABASE statement. The required privileges can be changed by using the -gu database server option.
The database you are encrypting must not be running.
Context and remarks
For strongly encrypted databases, store a copy of the key in a safe location. If you lose the encryption key, there is no way to access the data—even with the assistance of Technical Support. The database must be discarded and you must create a new database.
In Interactive SQL, connect to an existing database, other than the one you are encrypting.
Encrypt the database using the CREATE ENCRYPTED DATABASE statement.
The following statement takes the database file temp.db, and creates an AES-encrypted copy of it named encryptedtemp.db.
CREATE ENCRYPTED DATABASE 'C:\temp\encryptedtemp.db' FROM 'C:\temp\temp.db' KEY 'abc' ALGORITHM 'AES';
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|