Minimum requirements to run Sql Server BCP.exe utility

Question

I am working with a client who needs to do a data import to a remote SQL Server (2008) instance. The machine that the import will be done from cannot have SQL Server installed on it. Can the BCP.exe utility run without a SQL Server install?

Thanks for any help.

score 6 · Accepted Answer · answered Sep 08 '11 at 18:38

6

You have to use one of the SQL Server distributable packages to stay within licensing terms. These are not full installs.

The one you want is "Microsoft® SQL Server® 2008 R2 Command Line Utilities"

Note: copying bcp.exe by itself will not work

answered Sep 08 '11 at 18:38

gbn

70,237
8
167
244

score 1 · Answer 2 · edited Oct 01 '12 at 21:16

1

Copy bcp.rll from C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033.

Put bcp.exe & bcp.rll in the same folder.

That should allow BCP to run.

edited Oct 01 '12 at 21:16

Hannah Vernon

70,928
22
177
323

answered Jul 24 '12 at 12:40

petdeal

11
1

Minimum requirements to run Sql Server BCP.exe utility

2 Answers2