Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question

2 Answers 2

up vote 6 down vote accepted

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

share|improve this answer
    
Thank you for your help. –  Sako73 Sep 9 '11 at 13:22

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.