BCP on client machine

SQL Server Tools General

AnandaKumar.S


Hi,

What is the best practice to use BCP.exe to load text file from client machine to the SQLSERVER database installed in another server machine, without installing SQLSERVER client tools on the client machine.

Any suggestions is appreciated.

Thanks in advance.


-Anand


Top

Re: BCP on client machine

Jens K. Suessmeyer


You can use BCP on the client machine, but you will have to be aware to have a licencse for that. If you do not want to use BPC per se (becasue of this reason) you will have to implement it on your own, or by another third party data pump.


Jens K. Suessmeyer

---
http://www.sqlserver2005.de
---






Top

Re: BCP on client machine

AnandaKumar.S

Thanks for your reply.

Can anybody help me out in downloading the third party data dump tool. I heard about freetds, thats only for linux.

Any help is appreciated.

-Anand





Top

Re: BCP on client machine

Arnie Rowland

My understanding is that BCP is in the class of 'Client Tools' that are available to install on any client computer that is licensed with a CAL, or to access a SQL Server that is licensed with a Processor license.

For definitive answers about licensing, contact the licensing forks at:

Licensing ¨CMicrosoft, Contact
(800) 426-9400

From: http://www.microsoft.com/sql/howtobuy/faq.mspx

Do I need a separate license to run the SQL Server tools and analysis services
A.

No, a separate license is not required. However, any device that has SQL Server tools or technologies installed must have a valid SQL Server license.

Note: Most of the 'Client Tools' are NOT included with SQL Server 2005 Express Edition. There is, however, a special version of SQL Server Management Studio Express available.





Top