|
I am rebuilding a encrypted database in SQLA 17 The unload script created includes the statement PARAMETERS encryption_key; All LOAD TABLE statements include ENCRYPTED KEY '{encryption_key}' I intend to run this script with the dbisql.com utility How do I pass in the parameter "encryption_key" Thanks Jim |
"%SQLANY16%\bin64\dbisql.com"^
-c "ENG=ddd17; DBN=ddd17; UID=dba; PWD=sql"^
READ ENCODING Cp1252 "master.sql" [c:/temp/]
-- master.sql
PARAMETERS rootDir;
READ '{rootDir}MyDevScript1.sql';
READ '{rootDir}MyDevScript2.sql';
|
Hm, I have often rebuilt encrypted databases (via supplying -ep or -ek to the unload utility), and never have noticed those LOAD TABLE statements with ENCRYPTED KEY clauses, and therefore had not to supply parameters for those. Is this a database with table encryption (-et), not fully encrypted?