Skip to content

bulk-copy-operations-sql-server.md

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 Bulk copy operations in SQL Server
description 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.
author David-Engel
ms.author davidengel
ms.reviewer v-kaywon
ms.date 04/20/2021
ms.service sql
ms.subservice connectivity
ms.topic concept-article

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