Home > IT Answers > Development > Implementing Encrypted SQL Server Database Columns
Kansai
5 pts.
 Implementing Encrypted SQL Server Database Columns
.NET 2.0, SQL Server 2005, SQL Server database, SQL Server encryption, VB6
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
ASKED: December 5, 2009  10:12 PM
UPDATED: December 7, 2009  2:43 PM
RELATED QUESTIONS
Answer Wiki:
I posted some sample code on this <a href="http://www.tek-tips.com/faqs.cfm?fid=5964">FAQ</a> which shows how to use encryption in SQL 2005.
Last Wiki Answer Submitted:  December 6, 2009  10:53 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _