2012年3月19日星期一

BCP or BULK INSERT, which one is better to use.

Hi,
I have some data in ANSI txt file, i want to know which one would be
better and recommended way to import this into table. bcp or BULK
INSERT
Appreciate your inputs on this.
Thanks,
ManojPersonally, I use bcp , only because of the added flexibility that I can
also output into a data file
Jack Vamvas
________________________________________
__________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"Manoj" <manoj_poonia@.dell.com> wrote in message
news:1139581478.079428.98540@.g47g2000cwa.googlegroups.com...
> Hi,
> I have some data in ANSI txt file, i want to know which one would be
> better and recommended way to import this into table. bcp or BULK
> INSERT
> Appreciate your inputs on this.
> Thanks,
> Manoj
>|||Manoj (manoj_poonia@.dell.com) writes:
> I have some data in ANSI txt file, i want to know which one would be
> better and recommended way to import this into table. bcp or BULK
> INSERT
I seem to recall that I saw some numbers that indicated that BULK
INSERT is considerably faster than BCP.
However, with moderate volumes simplicity may be more important.
BULK INSERT requires that the file is visible from SQL Server. That
is, on the same machine as SQL Server, or a network drive that
SQL Server can see. For BCP there is no such requirement.
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

没有评论:

发表评论