Bcp.exe on client machine

Hi,
We use BCP.EXE to bulk upload to SQL Server. However, some of our clients
use SQL Server while others use MSDE.
We need to have BCP.EXE available on each client machine.
In case of a MSDE server does this mean that each client machine needs the
full MSDE installed just to get bcp.exe?
In case of the full SQL Server server does this mean that each client
machine needs a client tool like Query Analyzer installed just to get
bcp.exe?
Can I run SQLREDIS.EXE on a client machine instead and then just copy the
BCP.EXE and BCP.RLL files from the server machine instead? I read the
licenses but it is still unclear to me if this is allowed.
I've Googled to try find a solution but things are still as clear as mud.
Thanks in advance for any help,
Jako GroblerJako Grobler wrote:
> Hi,
> We use BCP.EXE to bulk upload to SQL Server. However, some of our
> clients use SQL Server while others use MSDE.
> We need to have BCP.EXE available on each client machine.
> In case of a MSDE server does this mean that each client machine
> needs the full MSDE installed just to get bcp.exe?
> In case of the full SQL Server server does this mean that each client
> machine needs a client tool like Query Analyzer installed just to get
> bcp.exe?
> Can I run SQLREDIS.EXE on a client machine instead and then just copy
> the BCP.EXE and BCP.RLL files from the server machine instead? I read
> the licenses but it is still unclear to me if this is allowed.
> I've Googled to try find a solution but things are still as clear as
> mud.
> Thanks in advance for any help,
> Jako Grobler
I'd just install the client utilities on every client machine (unless it's
a server at the same time). Disk space is cheap and this is definitely
the most hassle free solution - apart from licensing maybe.
Kind regards
robert|||"Robert Klemme" <bob.news@.gmx.net> wrote in
news:ONhaOCncFHA.3120@.TK2MSFTNGP12.phx.gbl:

> I'd just install the client utilities on every client machine (unless
> it's a server at the same time). Disk space is cheap and this is
> definitely the most hassle free solution - apart from licensing maybe.
> Kind regards
> robert
The problem is that the client utilities option is not available with MSDE.
Also, some companies are not happy installing Query Analyzer or Enterprise
Manager on client machines.
SQLREDIS.EXE does not install BCP.EXE, I tried it already.
:-(
Jako|||Jako Grobler wrote:
> "Robert Klemme" <bob.news@.gmx.net> wrote in
> news:ONhaOCncFHA.3120@.TK2MSFTNGP12.phx.gbl:
>
> The problem is that the client utilities option is not available with
> MSDE.
You can simply use SQL Server client utilities. They should happily
connect to an MSDE instance.

> Also, some companies are not happy installing Query Analyzer or
> Enterprise Manager on client machines.
Well then...

> SQLREDIS.EXE does not install BCP.EXE, I tried it already.
> :-(
> Jako
Kind regards
robert