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.