# Bulk Copy Program (BCP) — ManageEngine OpManager

## BCP (Only for Enterprise Edition or Standard/Professional Edition with the NFA addon)

The **"bcp.exe"** (Windows) or **bcp** (Linux), and **"bcp.rll"** must be available in the OpManager `bin` directory. The BCP utility provided with Microsoft SQL Server is a command line utility that allows you to import and export large amounts of data in and out of SQL Server databases quickly.

### For Windows

The **bcp.exe** and **bcp.rll** will be available in the MSSQL installation directory. If MSSQL is in a remote machine, copy **bcp.exe** and **bcp.rll** files and paste them into the `\OpManager\bin` directory.

**Note:** The SQL Server version compliant with the SQL Native Client must be installed in the same server.

### For Linux

For the BCP utility in Linux, **mssql-tools** (Microsoft ODBC driver for Linux) should be installed on the OpManager-installed machine. Please follow the steps in the document provided below to install the Microsoft ODBC driver on Linux servers:

[https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server](https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server)

**Note:**

- The command to install the ODBC driver is different for every Linux flavor. Please choose the correct Linux flavor and install the ODBC driver.

### Steps to move BCP utility to OpManager

After the ODBC driver is installed in Linux servers, the bcp utility files can be found in the below-mentioned paths. Copy both `bcp` and `bcp.rll` files to `<opmanager_home>/bin` and start OpManager once.

- **For ODBC driver version 18:**  
  - `bcp` file in `/opt/mssql-tools18/bin/`  
  - `bcp.rll` file in `/opt/mssql-tools18/share/resources/en_US/`

- **For other versions of ODBC:**  
  - `bcp` file in `/opt/mssql-tools/bin/`  
  - `bcp.rll` file in `/opt/mssql-tools/share/resources/en_US/`