up vote 1 down vote favorite
1
share [g+] share [fb]

I've been tasked with encrypting several years worth of sensitive data (don't ask) stored in a SQL Server 2000 Database. I need to encrypt both historical data and come up with a process to encrypt and decrypt new data as it flows through the system.

Most of the solutions out there seem to use extened stored procedures that call dlls that must be installed on the server.

The best I've seen so far is here, the tools are free but you have to register at the site.

Are there any better solutions out there?

link|improve this question
This is probably a Stack Overflow question. – Evan Anderson Jul 9 '09 at 19:11
I wasn't sure, as it may involve adding libraries to an SQL Server instance, it seemed more Server Fault-ish? – TGnat Jul 9 '09 at 19:16
feedback

4 Answers

up vote 3 down vote

Why not upgrade to sql 2008? Encryption is now built in and you'll get better performance on the same hardware.

link|improve this answer
feedback
up vote 1 down vote

There's nothing native in SQL Server 2000 that you can use. Anything that you find will have an extended stored procedure which will need to be installed on the system in order to work.

link|improve this answer
feedback
up vote 0 down vote

How about ROT13 twice... for double protection?

http://en.wikipedia.org/wiki/ROT13

LOL... sorry... couldn't resist. ;-)

On a more serious note... are you trying to encrypt/decrypt in the SQL server itself, or are you planning on doing the encrypt/decrypt at the application level?

I know there are various solutions out there for SQL Server 2005 and 2008 but since you have SQL 2000 you might just find that doing it at the application level is less of a headache.

link|improve this answer
As some of the processes run on different platforms (that I don't have control over) an application level solution seems unlikely. – TGnat Jul 9 '09 at 19:46
feedback
up vote 0 down vote

You may want to use Protegrity. I have used it successfully in a project and am quite happy with it.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.