BCP from Non SQL Servers

Question

Post reply

BCP from Non SQL Servers

showzain

SSC Veteran

Points: 221
More actions
November 22, 2007 at 5:20 am

#180687

Frens,
Is it possible to run bcp command from a box where you do not have sql server or client installed.
My opinion is NO.
What you say?
Regards
Javed Iqbal

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

karthik M One Orange Chip Points: 29139 More actions · Answer 1

Are you conducting interview ?;)

Yes you are correct. It is not possible without client installed in local machine.

karthik

showzain SSC Veteran Points: 221 More actions · Answer 2

Thanks.

No I am not conducting an interview.

Just to confirm and satisfy myself, I try to find out the best possible thoughts / opinion from the GURUs.

Thanks

Javed Iqbal

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 3

Actually, that may not be the case. Some of the tools, can be run even without a full client installation, if they are copied over or accessed from a network share. I don't know, however, if that's the case with bcp. You would still need the appropriate client licenses to be legal, but it may be able to run without a tool installaion.

K. Brian Kelley
@kbriankelley

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 4

Brian is correct...

Yes... you can copy and register just the two BCP files. But, it's against the law and it breaks the licensing agreement. Microsoft does NOT license BCP separately and they state that if you search the Microsoft web site. I believe I found the exact verbage in association with MSDE and I'd post the URL, except they changed it and I haven't searched for the new URL.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)