November 19, 2008 at 6:17 pm
Hi Folks,
I need to encrypt some data in tables (or perhaps the whole table). I am not keen to use the SQL inbuilt encryption because as far as I know it would mean the developers need to change the app to encrypt the data. Does anyone know any good third party apps for encryption?
November 20, 2008 at 7:20 am
Even if you use a third-party app to do encryption the developers would still need to change the app. There would have to be a step somewhere that encrypts and decrypts the data. If you are using stored procedures for data access then you could use SQL Server encryption without changing the app.
I prefer encrypting the data within the application, prior to sending it to SQL Server, because otherwise the data is unencrypted when traveling over the network to and from SQL Server.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply