---
schema_version: "1"
id: f596432c5ed84ee5c6e0bfe6bc687d537e80e770472b40df8148f48899497466
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/1.14/database-configure-usebulkcopy.md
canonical_url: https://docs.mulesoft.com/db-connector/1.14/database-configure-usebulkcopy
source_site: docs.mulesoft.com
content_type: documentation
content_hash: 8af310f1f59ee5ad4768d369739809166bf35bed724141679683d0dcc8b0a041
description: MuleSoft Documentation Site
release: "1.14"
latest: false
---
---
product: Database Connector
version: 1.14
---

# 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/1.14/_images/database-bulkcopy.png)

## See Also

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

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