[freetds] RE: bulk insert parallelism (was FreeTDS Digest, Vol 18, Issue 38)
Lowden, James K
LowdenJK at bernstein.com
Fri Jul 30 11:10:31 EDT 2004
> 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?
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. ;-)
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.
More information about the FreeTDS