• Question

  • If TDE is enabled on Database, Do we have to write some special code on application side to access data?
    Monday, March 23, 2015 2:22 AM


All replies

  • TDE is Transparent Data Encryption.  No code changes are required.  Data are encrypted on disk and decrypted automatically upon retrieval.

    Make sure you backup the certificate and public key as they will be needed to restore or move the database to another box.  See https://msdn.microsoft.com/en-us/library/bb934049.aspx

    Dan Guzman, SQL Server MVP, http://www.dbdelta.com

    • Proposed as answer by jmcmullen Monday, March 23, 2015 8:31 AM
    Monday, March 23, 2015 2:59 AM
  • Thank you Dan.
    • Marked as answer by VijayKSQL Monday, March 23, 2015 4:54 PM
    Monday, March 23, 2015 4:54 PM