Data Encryption (Entire tables)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Data Encryption (Entire tables)

  1. #1
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262

    Data Encryption (Entire tables)

    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!
    Last edited by hemanr; 10-21-2003 at 10:04 AM.
    Hemant

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Have a look at pgp to encrypt your files for ftp transmission
    http://www.pgp.com/

    steve
    I'm stmontgo and I approve of this message

  3. #3
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    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.
    Hemant

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    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...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    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.
    Hemant

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    Thank you so much Jeff!
    Hemant

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width