Skip to Content.
Sympa Menu

freetds - RE: [freetds] RE: FreeTDS Digest, Vol 18, Issue 40

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] RE: FreeTDS Digest, Vol 18, Issue 40
  • Date: Mon, 2 Aug 2004 08:49:09 +0100

Madhav,

taking a look at these pages, freebcp DOES support everything that Microsft
suugest you do to enable parallel data loads.

We do support the TABLOCK hint (via the -h flag to freebcp) and we do allow
you to manipulate the "rows per batch" value (via the -b flag). It looks
like the server takes care of the rest...


HTH,

Bill

-----Original Message-----
From: Satya Madhav [mailto:smadhav.vangara AT inucom.com]
Sent: 02 August 2004 08:42
To: freetds AT lists.ibiblio.org
Subject: [freetds] RE: FreeTDS Digest, Vol 18, Issue 40


Hi,
BCP utility support parallelism
Following are the links for parallelism in BCP
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsq
l/odp_tun_1a_5gyt.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/copromp
t/cp_bcp_61et.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsq
l/ad_impt_bcp_1968.asp


Parallelism in bcp: if a table is partitioned and support the parallel
loading of the data inot the same table then the facility can be
used.For that we need to have different data files and invoke different
bcp instances with diferent files.

This would be same as BULK INSERT T-SQL statement.
My question is doe freebcp supports this feature ??? An dwhat would be
syntax for it??



TIA
madhav



_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

==============================================================================

If you are not an intended recipient of this e-mail, please notify
the sender, delete it and do not read, act upon, print, disclose,
copy, retain or redistribute it.

Click here for important additional terms relating to this e-mail.
<http://www.ml.com/email_terms/>

==============================================================================





Archive powered by MHonArc 2.6.24.

Top of Page