1

Does anyone know how to install the bcp.exe in SQL 2017? If in MSSQL 2012 was easy to find during to install, in MSSQL 2017 Developer Edition apparently I cannot find it. Thanks!

SQL 2012

enter image description here

cdrrr
  • 1,138
  • 4
  • 13
  • 44
  • 1
    "The bcp 13.0 client is installed when you install Microsoft SQL Server 2017 tools" - Source: https://learn.microsoft.com/en-us/sql/tools/bcp-utility#remarks – Peter B Jan 08 '18 at 12:28
  • 1
    `bcp` is not the native client but the command line bulk copy utility. The native client is the OLE DB/ODBC driver for SQL connectivity from programs. – Jeroen Mostert Jan 08 '18 at 12:30
  • Ok. But i need to use the `bcp.exe` application. Where can I find it? – cdrrr Jan 08 '18 at 12:31
  • 1
    Standalone, it's part of the [SQL Server 2016 feature pack](https://www.microsoft.com/en-us/download/details.aspx?id=52676) (`ENU\\MsSqlCmdLnUtils.msi`). AFAICT there is no newer version for 2017; the 2016 version is fully compatible. I don't know what checkbox in the main SQL Server setup you have to tick for it, if any. – Jeroen Mostert Jan 08 '18 at 12:33

1 Answers1

3

SQL Server client tools are being decoupled from the server components in later SQL versions. This includes SSMS as well as command-line utilities. Below are some links.

Dan Guzman
  • 43,250
  • 3
  • 46
  • 71