Hello,

We need to encrypt our data going to an Oracle 11.2g Standard database, but we cannot afford to pay $25,000 to Oracle for their Enterprise Edition so we could use their secured backup and Transparent Data Encryption, so we need to encrypt/decrypt our entity field data ourselves. Can you please provide some guidance as to the best way to implement encryption within your generated code? I know how to do the encryption/decryption, I just need to know where to insert code to encrypt/decrypt fields and the best way to accomplish this task given your architecture.

Thank you very much for your help!

Mike

How would you like to have it added?

Data stored encrypted in the db and decrypted somewhere? Or stored normally but encrypted somewhere? And how would you like to specify the keys for en/decryption?

Related threads: http://llblgen.com/tinyforum/Messages.aspx?ThreadID=2885 http://llblgen.com/tinyforum/Messages.aspx?ThreadID=11220 http://llblgen.com/tinyforum/Messages.aspx?ThreadID=14929

Wow! I didn't find as many references as you did, Daelmo! Thank you very much! The good news is that I will not have to create our own field level encryption! Since my posting, we had a very lively debate about Oracle vs SQL Sever, features, costs, performance, and we've decided to migrate to SQL Server Enterprise. The great news is that it took me about 8-minutes to configure Transparent Data Encryption on our databases! Wow! Problem solved! Anyway, we are good to go...

Thank you again for your help! Have a great holiday season!

Mike