|
I have a database which currently is using by my application. I dodn't want to change anything in my application CORE. But I want to encrypt
How to get it to work? Encryption is needed for all of the fields in Database, numerics, strings, booleans, datetimes, etc. Any help is appriciated |
|||
| add comment |
|
If you want cell level Encryption you should do it yourself (using |
|||||
|
|
SQL 2008 has TDE or, Total Database Encryption. This encrypts the entire database and is transparent to any users of the database. The details of how to go about it can be found in these two Microsoft articles: http://msdn.microsoft.com/en-us/library/cc278098%28v=sql.100%29.aspx |
|||||
|
|
You may substitute your real table with a VIEW add INSTEAD OF INSERT and INSTEAD OF UPDATE triggers, create several User Defined Functions. You'd probably need to modify your application slightly. Instead of that, consider using encryption on file level with schema protection. Such tools like DbDefence available in free edition for small databases and very moderate price for mid-size databases. |
|||
|
|
DBAalso can remove, add or edit any structures(DON'T forget that these are DBAs job). I just want to encrypt Information inside tables – Nasser Hadjloo Jan 12 '12 at 9:34