---
schema_version: "1"
id: a57bad651d8a0d35f58937e8d7f53dac888c78ca6d90634057246329a6c0d01d
title: Configure Use Bulk Copy for Database Connector SQL Server Connection
collection: mulesoft
version: current
locale: en-us
portal_url: https://docs.salesforce.com/mulesoft/current/en-us/db-connector/latest/database-configure-usebulkcopy.md
canonical_url: https://docs.mulesoft.com/db-connector/latest/database-configure-usebulkcopy
source_site: docs.mulesoft.com
content_type: documentation
content_hash: 9e5175b300891b217cd72333e6b085ce03cfa86710261f7c12e4454b0b90802d
description: MuleSoft Documentation Site
release: "1.16"
latest: true
---
---
product: Database Connector
version: 1.16
is-latest-version: true
---

# Configure Use Bulk Copy for Database Connector SQL Server Connection

> For the full documentation index, see: https://docs.mulesoft.com/llms.txt

You can configure the bulk copy for batch insert in Anypoint Connector for Database (Database
Connector) for the Microsoft SQL Server Connection. This feature allows you to enable the driver to
do bulk copy operations when executing batch insert operations. Configure this feature as a
connection property in the Database Connector Configuration screen.

1.  In Studio, navigate to the **Global Elements** tab.

2.  Click **Create**.

3.  In the search bar, type `database`.

4.  Select **Database config**.

5.  Click **OK**.

6.  In the **Global Elements Properties** screen, set **Connection** to **Microsoft SQL Server
    Connection**.

7.  Click the **Advanced** tab.

8.  Set **Connection properties** to **Edit inline**.

9.  Click the plus sign to add a new property.

10. In the **Connection property** screen, set **Key** to `useBulkCopyForBatchInsert`.

11. Set **Value** to `true`.

![useBulkCopyforBatchInsert property created under the Connection property section](/mulesoft/current/en-us/db-connector/latest/_images/database-bulkcopy.png)

## See Also

- [Database Connector Examples](https://docs.mulesoft.com/db-connector/latest/database-connector-examples)

- [Salesforce Help](https://help.salesforce.com)