This is the problem I'm facing:
The database (SQL Server 2005) holds more than 5 million customer records.
These records contain sensitive credit-card information that must be encrypted.
Implementing an application-side encryption solution involves VB6 and .Net technologies.
How to achieve a server-side encryption solution that would have minimal impact on performance and business processes?
Applying Encryption to Database; Finding and Decrypting a Record
I would like to know your opinion and advice.
Thanks in advance.
Software/Hardware used: SQL Server 2005, VB6, .Net 2.0