Field level encryption...

• swjohnson

  Hall of Fame

  Points: 3254

  More actions

  February 24, 2004 at 9:21 am

  #84292

  Just looking for others who have had to implement field level encryption their databases. 

  A. What program/utility did you decide on?  We have been looking at dbEncrypt from Appsec Inc. 

  B. What performance impact did you encounter? 

  C. Did you have to re-write many of the stored-procs? 

  D. What processes also had to change like back-up and disaster recover?

  Thanks

  SJ

   

  

  ---

  Accepting all invites

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  February 24, 2004 at 9:29 am

  #495352

  Personally I think it's a bad idea (http://www.sqlservercentral.com/columnists/sjones/wp_encryption.asp), but if you have to do  it, then key management will be the biggest headache. For live data as well as backup/recovery.

  One hint, be sure you have a good bulk decryption/encryption scheme for changing the key if needed.