(i) BCP is command line utility where as bulk insert is t-sql statement.
(ii) BCP can be used for import And export where as bulk INSERT for import only
(iii) While importing Large text files, bulk insert is proven to be faster than BCP because bulk insert converts the data into TDS (tabular data stream) , which is sql server complaint whereas BCP converts data into ODBC data Stream ,
again which has to be converted into TDS.
No comments:
Post a Comment