Skip to content

Latest commit

 

History

History
46 lines (33 loc) · 2.52 KB

bulk-copy-operations-sql-server.md

File metadata and controls

46 lines (33 loc) · 2.52 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic
Bulk copy operations in SQL Server
Describes bulk copy functionality in the SqlClient .NET Data Provider for SQL Server. Bulk copy is a fast way to load large amounts of data into SQL Server.
David-Engel
v-davidengel
v-kaywon
04/20/2021
sql
connectivity
conceptual

Bulk copy operations in SQL Server

[!INCLUDEDriver_ADONET_Download]

Microsoft SQL Server includes a popular command-line utility named bcp. Bcp is used to quickly bulk copy large files into tables or views in SQL Server databases. The xref:Microsoft.Data.SqlClient.SqlBulkCopy class allows you to write managed code solutions that provide similar functionality. There are other ways to load data into a table (INSERT statements, for example) but xref:Microsoft.Data.SqlClient.SqlBulkCopy offers a significant performance advantage over them.

Using the xref:Microsoft.Data.SqlClient.SqlBulkCopy class, you can perform:

  • A single bulk copy operation
  • Multiple bulk copy operations
  • A bulk copy operation within a transaction

Note

When using .NET Framework version 1.1 or earlier (which does not support the xref:Microsoft.Data.SqlClient.SqlBulkCopy class), you can execute the SQL Server Transact-SQL BULK INSERT statement using the xref:Microsoft.Data.SqlClient.SqlCommand object.

In this section

Bulk copy example setup:
Describes the tables used in the bulk copy examples and provides SQL scripts for creating the tables in the AdventureWorks database.

Single bulk copy operations:
Describes how to do a single bulk copy of data into a database instance using the xref:Microsoft.Data.SqlClient.SqlBulkCopy class. It includes how to do the bulk copy operation using Transact-SQL statements and the xref:Microsoft.Data.SqlClient.SqlCommand class.

Multiple bulk copy operations:
Describes how to do multiple bulk copy operations of data into a database instance using the xref:Microsoft.Data.SqlClient.SqlBulkCopy class.

Transaction and bulk copy operations:
Describes how to do a bulk copy operation within a transaction, including how to commit or roll back the transaction.

Order hints for bulk copy operations:
Describes how to use order hints to improve bulk copy performance.

Next steps