HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Minimum requirements to run Sql Server BCP.exe utility

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
exesqlminimumutilitybcpserverrequirementsrun

Problem

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.

Solution

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

Context

StackExchange Database Administrators Q#5541, answer score: 6

Revisions (0)

No revisions yet.