|
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. |
|
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
1
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
|
