I am testing software to encrypt columns in sql tables. It's an interesting experience. Typically such software renames the base table containing encrypted columns and creates a VIEW having the name of the original table. The idea is to make the transformation have as little impact as possible at the source code level. I applied one company's package to a test databases (pretyy complex ones) and found out... after much trouble .... that I couldn't de-crypt the very columns I had encryped! Yes, I can encrypt\decrypt Northwind with their product, I am working with the company on this one.
I also found that DTS no longer recognized the table name and that QA, expecting to display text, would sometimes freak out when it hit an encrypted (binary) field.
That's my sob story. Now I'm chechking out the products of Protegrity hoping to have greatr success.
Can you recommed database encryption software for me to test?