CODEWITHSUNDEEP
sqlsql-server-2008
John Egbert
John Egbert

Reputation: 5776

What are the advantages/disadvantages of SQL Server bulk insert?

What are the advantages/disadvantages of SQL Server bulk insert?

advantages/disadvantages vs regular single row inserts while an app is processing data.

Upvotes: 2

Views: 7409

Answers (2)

subhrasnu
subhrasnu

Reputation: 1

BCP is used for the BULK data load in sql server.Here are few advantages listed below.

  1. BCP transaction is much more faster than other means
  2. We can migrate fixed length file, comma separated file using BCP command.
  3. BCP can be used from .Net code for data migration.

Upvotes: 0

David W
David W

Reputation: 10184

I think the basic purpose for bulk insert is to allow for keys/constraints to be suspended while a large amount of data is imported, which would be much quicker than a conventional record-by-record/programmatic INSERT..not sure there is a "disadvantage," unless you try to use it in a scenario where it wasn't really designed/intended.

Upvotes: 4

Related Questions