Is BCP secure?

Posted on 2004-10-31
Last Modified: 2012-06-27
I have generated a batch file using BCP to backup my database through the Internet. I wonder if the connection is Secured or not. As far as I know this is a BULK COPY procedure but do not have any Idea what happens if somebody sniffs the packets.
Looking forward to your comments helping me protect the connection for BCP if is not.

Question by:persheng
    LVL 2

    Accepted Solution

    No, BCP is not secure.  I've never actually thought about doing BCP over the internet, but I suppose you could script the BCP jobs to work on the remote server then use a secure FTP client to move the data to your local machine.  You could also use a VPN client to connect to the remote network, though the bcp would still not be secure within that network.  It would probably be easiest to go the local BCP route with secure FTP, assuming you are set up with a secure FTP site on the network or system where your database server lives.
    LVL 13

    Expert Comment

    Got to agree with you there, BCP is not secure at all.  It should only be used on the same machine as the server itself unless you have some form of IPSEC encrpyption going on over your network.  It is a tool that has a function, no tool alone is secure -- looking at a secure FTP server, will still require work to ensure you get firewalls put in place, some anti-hacking processes developed, .... etc...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Learn The Basics of Ethical Hacking & Pen Testing

    Computer and network security is one of the fastest growing and most essential industries in technology, meaning companies will pay big bucks for ethical hackers. This is the perfect course to leap into this lucrative career, learning how to use ethical hacking to reveal ...

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    857 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now