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

asked 08 Mar, 13:30

J%20Diaz's gravatar image

J Diaz
1.1k293857
accept rate: 10%

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?

(08 Mar, 14:38) Volker Barth

"%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';
permanent link

answered 08 Mar, 14:25

Breck%20Carter's gravatar image

Breck Carter
31.4k5056941014
accept rate: 20%

You are a genius, thanks

(08 Mar, 14:31) J Diaz
Comment Text Removed
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×21

question asked: 08 Mar, 13:30

question was seen: 91 times

last updated: 08 Mar, 15:49