After TDE is implemented will application SQL have to change?
I am researching the implementation of TDE. I understand how to implement it (after some Google, some Bing ). And I get that I need to backup the certificate files (a lot) My question is this "After the SQL user logs on, Will any changes be needed in the actual TSQL statements themselves? I have a very active website using the database to be encrypted, and I don't want to have to make a ton of changes. As I understand it, it just encrypts the files (logs, data) and does the same with the temp db? no change will need to be made from there? I don't want to go to far without knowing all the details. Last not really a question. More of wondering how it will work. I have implemented several temp db scattered over SAN server LUNs. Performance is awesome. I am guessing they all get encrypted? Assigned a temp db to a database is out of question right? (may be Microsoft can do that in version 9090.... :) Any knowledge on the subject would be appreciated! I have attempted to Google and Bing this very question and I am just not asking it right somehow.