Post reply

BCP over internet

  • January 18, 2003 at 7:34 am

    #174889

    Gents,

    Which is the best and secure way to send data over the internet then put then into a database.

    Basicaly I would need to bcp the data transmitted over the internet into a table.

    SQL2K Ent ed. W2k Adv. Server, the webserver is Apache on Linux using PHP.

    Any idea?



    Bye
    Gabor

  • January 21, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • January 21, 2003 at 5:49 pm

    #446929

    If you use a VPN its reasonably secure. Another option would be to zip with password (or find a similar compression util with better security) and FTP. Depending on size of the data and the connection speed/reliability, might be better to get the file onto the server first, then do the import.

    Andy

    http://qa.sqlservercentral.com/columnists/awarren/

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply