Hi. Our company is has adopted new security rules for handling customer data. What is the easiest way to encrypt a database? For trouble-shooting, I sometimes have to bring a copy of a customer's SQLA database to my workstation. My process will be to make a backup of the database, zip/encrypt the log and DB file, ftp the encrypted zip file to my workstation, then unencrypt/unzip the db. While the database resides on my workstation, I would the like for the database to be encrypted and require that a password/key be supplied whenever the database is initially accessed. Our application accesses the SQLA DB through ODBC. I will also use Sybase central against the DB. Thank you.

asked 13 Dec '13, 18:10

dejstone's gravatar image

accept rate: 0%

permanent link

answered 14 Dec '13, 03:59

Dmitri's gravatar image

accept rate: 11%

If you have a recent SQL Anywhere Version, then go for the database encryption as mentioned in the link above.

(14 Dec '13, 05:37) ASchild

Also note that once the database is encrypted there will not be much savings (in space) by zipping the files - encrypted data does not compress.

(14 Dec '13, 07:30) Mark Culp
Your answer
toggle preview

Follow this question

By Email:

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



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:


question asked: 13 Dec '13, 18:10

question was seen: 2,208 times

last updated: 14 Dec '13, 07:30