# 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 **\OpManager\bin** directory.

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

## For Linux

For BCP utility in Linux, **mssql-tools** (Microsoft ODBC driver for Linux) should be installed on an OpManager installed machine. Please follow the steps in the document provided below to install 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 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 path. 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/` and bcp.rll file in `/opt/mssql-tools18/share/resources/en_US/`

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