Encryption - SQL Server 2000 1

[SQLBill]

I have a tasking. Specific data needs to be encrypted to 256 or better. I'm specifically concerned about the data in SQL Server databases, but a solution that would work for several db's (Oracle, etc) would be best.

Does anyone know of a product that encrypts data on the database?

I need to be able to have all new data encryted and all legacy data encrypted. The best solution for me would be to have the front end do all the encryption, but that doesn't solve the issue with data already on the database.

My preference is either a front-end solution or a 'middle man' solution. I believe that we should not be encrypting data in the database, it should be encrypted before it is stored and decrypted once it is taken off the database.

-SQLBill

Posting advice: FAQ481-4875

 

[mrdenny]

I would agree that the encryption shouldn't be taking place within the database if it can be avoided. In order to do the encryption of the data already in the system your best bet may be to write a one off app to process all the data already in the system. Then have the front end handle the encryption of the new data.

If you end up doing the encryption within the database you can use

http://www.sqlservercentral.com/columnists/mcoles/freeencryption.asp

this. I think it covers your requirments.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLBill]

Thanks....I've found the free encryption tool and the updated version.

I started a new job (moved to Arizona) and they are trying to get encryption going. I've told them the app needs to do all the work since a db is just a storage place for data. But as the 'newbie', my opinion needs backing up (the other DBA's said 'huh'??? to the request).

Thanks again.

SQLBill

Posting advice: FAQ481-4875

 

[mrdenny]

Congrats on the new job.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLBill]

Thanks....I'm getting to actually do a lot of the things that I've learned but was not allowed to do in my previous job.

-SQLBill

Posting advice: FAQ481-4875