Post reply

BCP utility

  • February 2, 2010 at 5:22 am

    #96886

    One of the WEB Server Application using BCP utility . Database located another server. Could you tell me, Is it required SQL client need to be install in application server then only BCP will work in application side?

    I am think In enterprise manager, if Bulk insert Administrator server role option is enable, will it work?

    Thanks for advance - SQLDBAs

  • February 3, 2010 at 4:33 pm

    #1113331

    I think you can get around having to install the SQL client tools. You could run the BCP from the application server direct to the database server as long as you specify the security credentials within the BCP.

    I'm not 100% sure it will work but copy the files bcp.exe and bcp.rll from the SQL Server\Tools\Binn folder on the db server and place them on your app server. Give it a go and see. Let me know how it goes.

  • February 3, 2010 at 5:30 pm

    #1113357

    Shark Energy (2/3/2010)

    I'm not 100% sure it will work but copy the files bcp.exe and bcp.rll from the SQL Server\Tools\Binn folder on the db server and place them on your app server. Give it a go and see. Let me know how it goes.

    I had a similar problem and it turns out that making such a copy violates the license agreement. In other words, it's against the law to do that.

    --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)

  • February 4, 2010 at 2:28 am

    #1113562

    What if you have the license though? But you don't want to install all of the client tools?

    If the questions to my above are "Doesn't matter, it breaks the license" then please ignore my advice!

    Any advice passing through me assumes the user is following all licensing laws!

  • February 5, 2010 at 4:20 pm

    #1114842

    Admittedly, I've not look at the license recently but it used to say something about having to install the entire client and not just parts. So I suspect the "Doesn't matter, it breaks the license" observation still holds true.

    But you shouldn't take anyone's word for such a thing. Read the license.

    --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)

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

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