Question Re: Encrypt Database Output in Technology Q&A

Encrypt Database Output

Former Member — Tue, 30 Aug 2011 06:24:59 GMT

Want to be able to select from a SQL Anywhere Database and output to a CSV file and encrypt that file and send it to my client who does not have sql anywhere but should be able to decrypt the file. So do i install SQL Anywhere Client on the client machine so they can decrypt or need a full SQL Anywhere insttallation.

Regards,

Re: Encrypt Database Output

VolkerBarth — Tue, 30 Aug 2011 07:58:25 GMT

If you are refering to the ENCRYPT()/DECRYPT() functions, they are processed on the server and are only available by sending queries against the server.

So it won't help your customer to just have a SQL Anywhere client install available.

Cf. this FAQ where I have asked for client-side support of such encryption tasks...

Personally, I would simply use something like WinZip or WinRar to encrypt the files.

Re: Encrypt Database Output

graeme_perrow — Tue, 30 Aug 2011 07:59:57 GMT

You can use the encrypted clause with the unload select statement to create an encrypted file containing the data, but your client will need to use the load table statement to decrypt the data. This means that the client will need a full installation of SQL Anywhere.

Alternatively, you could use the unload select statement to create the file, and then use some non-SQL Anywhere technology to encrypt the file.