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?