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

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

## See Also

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

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