Implementing Encrypted SQL Server Database Columns

5 pts.
Tags:
.NET
SQL Server
SQL Server 2005
SQL Server database
Visual Basic 6
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following