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

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/

 

 
 Pricing  Get Quote