Skip to Content.
Sympa Menu

freetds - RE: [freetds] RE: bulk insert parallelism (was FreeTDS Digest, Vol 18, Issue 38)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Lowden, James K" <LowdenJK AT bernstein.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] RE: bulk insert parallelism (was FreeTDS Digest, Vol 18, Issue 38)
  • Date: Fri, 30 Jul 2004 11:10:31 -0400

> I would like to use BCP utility for SQL Server to load data
> from a UNIX box...
> I know there is freebcp and freetds freeware to do that
> But will they
> support the parallelism provided by the bcp given by the
> Microsoft SQL Server?

Satyamadhav,

Perhaps you could provide a link to the page on Microsoft's web site
that describes the feature you're talking about? Because I don't know
of any parallelism provided by any bcp utility.

FreeTDS was developed by reverse engineering the protocol, by inspecting
and reproducing the bits on the wire. The server cannot distinguish
between FreeTDS's freebcp and the vendor's own bcp utility, because they
read/write the same bits.

As a comparison of the documentation shows, there are some features
Microsoft's bcp.exe provides that freebcp does not, but I can't think of
anything called "parallelism".

So, I guess the answer to your question is: Yes. ;-)

--jkl


-----------------------------------------
The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above. If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the original
message. Please note that we do not accept account orders and/or instructions
by e-mail, and therefore will not be responsible for carrying out such orders
and/or instructions.
If you, as the intended recipient of this message, the purpose of which is to
inform and update our clients, prospects and consultants of developments
relating to our services and products, would not like to receive further
e-mail correspondence from the sender, please "reply" to the sender
indicating your wishes. In the U.S.: 1345 Avenue of the Americas, New York,
NY 10105.






Archive powered by MHonArc 2.6.24.

Top of Page