.netsql-serverbcp

Installing BCP without installing SQL Server in client machine?


I export data from database using the BCP utility, I want to install bcp in client machine. I don't want to install SQL Server 2008 in client machine.

Is their any minimal installers available to install just bcp?

This is urgent task. Thanks in advance


Solution

  • You have to use one of the SQL Server distributable packages to stay within licensing terms. Specifically "Microsoft SQL Server 2008 Command Line Utilities"

    Note: copying bcp.exe by itself will not work

    Edit: latest download link: SQL Server distributable packages

    Edit: an even later download link: SQL Server 2008R2 Feature Pack