Installing BCP without installing SQL Server in client machine?

Question

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

score 11 · Accepted Answer · edited Oct 22 '13 at 21:46

11

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

edited Oct 22 '13 at 21:46

RThomas

10,702
2
48
61

answered Mar 14 '11 at 05:23

gbn

422,506
82
585
676

I Installed --> sqlncli.msi (Microsoft SQL Server Native Client ) SqlCmdLnUtils.msi (Command Line Utils), Even I can not able to use bcp – Ramakrishnan Mar 14 '11 at 05:29
@gpn : I Solved the problem by Setting Up Path (In Environmental Variable). thanks – Ramakrishnan Mar 14 '11 at 06:09
@Ramakrishnan: this is often caused by an old install of SQL Server tools which has changed PATH previously – gbn Mar 14 '11 at 07:44
1

@gbn Just stumbled across your answer. Second link is broken. +1 for general awesomeness. – Nick Vaccaro Jan 31 '13 at 14:42

score 9 · Answer 2 · answered Feb 03 '15 at 13:44

9

2015 - Installed on Windows Server 2008 R2 SP1

I needed the ODBC driver installed first...

Microsoft® ODBC Driver 11 for SQL Server

http://www.microsoft.com/en-za/download/details.aspx?id=36434

Microsoft® Command Line Utilities 11 for SQL Server

http://www.microsoft.com/en-za/download/details.aspx?id=36433

p.s. In case you're reading this post and the year is > 2015, use the search to find a similar download:

http://www.microsoft.com/en-za/search/DownloadResults.aspx?q=Microsoft%20Command%20Line%20Utilities

answered Feb 03 '15 at 13:44

AEQ

1,339
1
16
20

2

I like the link to the search. I did, however, change the search term to `microsoft sql server feature pack`, as the results are named after a SQL Server version, which is more user friendly. The first links are only relevant for SQL Server 2014, and the search was useful for me to find older versions as well. Thanks. – Roi Gavish Mar 31 '15 at 09:12
If you use chocolatey, there is also a [sqlserver-cmdlineutils package](https://chocolatey.org/packages/sqlserver-cmdlineutils) available that includes bcp and takes care of all the dependencies. `choco install sqlserver-cmdlineutils` – Matt Scully Oct 11 '16 at 19:14

score 3 · Answer 3 · answered May 18 '23 at 16:59

BCP comes with "Command Line Utilities" package. You need to install "ODBC driver" first. Sending you the links for download

Microsoft ODBC Driver 17 for SQL Server - Direct Download Link

Microsoft Command Line Utilities 15 for SQL Server (x64) - Direct Download Link

score 2 · Answer 4 · edited Dec 09 '13 at 10:48

2

well,just put the file below into c:/windows/

sqlncli.dll
bcp.exe
bcp.rll

i tested on windows xp with which the 3 files come from sql server 2005 client

edited Dec 09 '13 at 10:48

kleopatra

51,061
28
99
211

answered Dec 09 '13 at 10:31

cwalet

189
1
3
11

Installing BCP without installing SQL Server in client machine?

4 Answers4

Related