Installing SQL Srv 2005 commandline utilities.

I'm being asked to "install" SQL Server 2005 "client tools" on high
performance compute (HPC) nodes for researchers who use SQL. the 2005 client
is a bit heavy on disk space, etc, etc. and I'm looking for info on how to
install the commandline tools only (that's all they really need).

Is that possible? Is it documented? TIA.

me (me@discussions.microsoft.com)  writes:
> I'm being asked to "install" SQL Server 2005 "client tools" on high
> performance compute (HPC) nodes for researchers who use SQL. the 2005
> client is a bit heavy on disk space, etc, etc. and I'm looking for info
> on how to install the commandline tools only (that's all they really
> need).
>
> Is that possible? Is it documented? TIA.

Have you tried running the regular SQL 2005 setup, and in the Advanced
screen try to make a selection that comprises only command-line tools?
I don't remember offhands if there is any such choice.

An alternative would be the SQL Express installation. I believe you
can make a tools-only installation of SQL Express. I expect this to
give you the command-lines tools BCP, SQLCMD and OSQL as well as the
SQL Configuration Manager and the Surface Area Tool. Your users will not
need the latter two, but I would expect them eat that much disk.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

It's documented in SQL2005 Books Online
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420
-78a57852364d.htm#addlocal).
More specifically, check out the parameter ADDLOCAL and value Client
Components.

Linchi

"me" wrote:

> I'm being asked to "install" SQL Server 2005 "client tools" on high
> performance compute (HPC) nodes for researchers who use SQL. the 2005 clie
nt
> is a bit heavy on disk space, etc, etc. and I'm looking for info on how to
> install the commandline tools only (that's all they really need).
>
> Is that possible? Is it documented? TIA.

From
http://www.microsoft.com/downloads/...&displaylang=en

Install the Microsoft SQL Server Native Client AND Microsoft SQL Server
2005 Command Line Query Utility

Tim S

We ended up finding the same info Linchi provided and going with that.
Simplest, fastest way from our perspective.

Thanks everyone.

"Linchi Shea" wrote:

> It's documented in SQL2005 Books Online
> (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a4
20-78a57852364d.htm#addlocal).
> More specifically, check out the parameter ADDLOCAL and value Client
> Components.
>
> Linchi
>
> "me" wrote:
>