How do we update the Database using BCP utility
if there is no sql server installed in the client
machine......

Is there any alternative to update Database
instead of DTS and BCP Utilities


regards
Rajnikant Bal

Have you tried just copying the BCP utility to the client machine.

Also, I think this would be better in an SQL forum, rather than the C# forum.

/- Sam Judson : Wrox Technical Editor -/

Thankx for your suggestion SAM
but i forget to mention that i am
calling the bcp process from my windows application


Previously i used to call a stored proc to update table in
Database1... and in result there was a trigger which updated the
table in different Database2...

It was too cumbersome and took lot of time to load and update
Then i thought of using BCP/DTS for updating the tables in the
database and then call a stored proc which updates the other database



But if we go for BCP/DTS then we have to install it in the
client side, which is again a overhead



So my issue was whether there is any other alternative
other than bcp/dts to
copy table values from file to database or vice-versa.

rajnikant january 16

DTS is a server based technology (not client), so that would be the solution if the trigger is taking too long to update - rather than having everything in the trigger simply put it in a DTS package and have the trigger start the DTS pacakge.

/- Sam Judson : Wrox Technical Editor -/