SQL server TDE - What needs to change in the front end


One of our clients reached out to us asking if our application supports SQL TDE encrypted database.
We haven't tested our applications against a SQL Server TDE encrypted database.

As far as I know, TDE encrypts data at rest, not in transit. That would mean there is no need for our application to change.

  • Am I right or do we have to make any application changes?
  • do we have to do a regression test on our application against the database that is encrypted using TDE to make sure ?

Thank you

We didn't change anything when we used it. We have 8 databases and only 1 was using TDE. We deployed the same code everywhere. The only issue was a lag when syncing using Availability Groups.

Great. Thanks