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

1

Hello,

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

2

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.

3

Great. Thanks