locked
SQL TDE RRS feed

  • 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

Answers

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