Data Encryption (Entire tables)

[hemanr]

Hi Folks,

My requirement is to port data to another geographic location where it will be repopulated into a database.
This data when sent needs to be encrypted.
We would be using simple .dat files to extract the data at my end and FTP these files to the target where they would be populated using sql loader. The data at target would be decrypted.


I have no idea how to go about this. Any suggestions would be welcome.

Thanks!

[stmontgo]

Have a look at pgp to encrypt your files for ftp transmission
http://www.pgp.com/

steve

[hemanr]

Thanks for the pointer Steve, but Im not looking at an additional investment or keys.
I was thinking more on the lines of encrypting my .dat files or the data itself prior to ftp.
I was also wondering if there is an option to encrypt stuff sent across, within ftp itself.
I did find EFTP for windows.

[marist89]

PGP is free and very easy to setup. If you're that concerned about encryption, I'd use it.

If your data is that sensitive maybe you should burn it on a CD and ship it overnight...

[hemanr]

Hi Jeff,

Thanks!
I think I could not find the actual info I needed when I was going through the PGP website.
I did look under products but was unable to locate the download.

[marist89]

http://web.mit.edu/network/pgp-form.html

[hemanr]

Thank you so much Jeff!