Database Experts help please
Hi
Does anyone know if its possible to encrypt data within an SQL 2005 database. I urgently need to remediate an issue for some data that needs to be protected within the database. Does anyone know if this is possible. I did a quick google but I'm getting some conflicting answers. I would really appreciate any help.
Thanks
Does anyone know if its possible to encrypt data within an SQL 2005 database. I urgently need to remediate an issue for some data that needs to be protected within the database. Does anyone know if this is possible. I did a quick google but I'm getting some conflicting answers. I would really appreciate any help.
Thanks
Comments
-
NotHackingYou
Member Posts: 1,460 ■■■■■■■■□□
I think what you are looking for is called column level encryption. I have set this up before, it's not super hard but you will need to work with it a bit to get the hang of it. Your application also must be able to handle the encrypted value. Here's the MSDN on it: How to: Encrypt a Column of DataWhen you go the extra mile, there's no traffic. -
NightShade03
Member Posts: 1,383 ■■■■■■■□□□
@CarlSaiyed is correct. You can do column level encryption or full table encryption. Here is a similar article:
Encrypt a Column of Data
You can also leverage a third party tool like Voltage to assist or use the programming language to encrypt the data before it is inserted into the database.