---
title: Install SQL Server command-line tools on Linux | Microsoft Docs
description: This topic describes how to install the SQL Server Tools on Linux.
author: rothja
ms.author: jroth
manager: jhubbard
ms.date: 10/02/2017
ms.topic: article
ms.prod: sql-linux
ms.technology: database-engine
ms.assetid: eff8e226-185f-46d4-a3e3-e18b7a439e63
---
# Install sqlcmd and bcp the SQL Server command-line tools on Linux
[!INCLUDE[tsql-appliesto-sslinux-only](../includes/tsql-appliesto-sslinux-only.md)]
The following steps install the command-line tools, Microsoft ODBC drivers, and their dependencies. The **mssql-tools** package contains:
- **sqlcmd**: Command-line query utility.
- **bcp**: Bulk import-export utility.
Install the tools for your platform:
- [Red Hat Enterprise Linux](#RHEL)
- [Ubuntu](#ubuntu)
- [SUSE Linux Enterprise Server](#SLES)
- [macOS](#macos)
- [Docker](#docker)
This topic describes how to install the command-line tools. If you are looking for examples of how to use **sqlcmd** or **bcp**, see the [links](#next-steps) at the end of this topic.
## Install tools on RHEL 7
Use the following steps to install the **mssql-tools** on Red Hat Enterprise Linux.
1. Enter superuser mode.
```bash
sudo su
```
1. Download the Microsoft Red Hat repository configuration file.
```bash
curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/msprod.repo
```
1. Exit superuser mode.
```bash
exit
```
1. If you had a previous version of **mssql-tools** installed, remove any older unixODBC packages.
```bash
sudo yum update
sudo yum remove unixODBC-utf16 unixODBC-utf16-devel
```
1. Run the following commands to install **mssql-tools** with the unixODBC developer package.
```bash
sudo yum update
sudo yum install mssql-tools unixODBC-devel
```
> [!Note]
> To update to the latest version of **mssql-tools** run the following commands:
> ```bash
> sudo yum check-update
> sudo yum update mssql-tools
> ```
1. **Optional**: Add `/opt/mssql-tools/bin/` to your **PATH** environment variable in a bash shell.
To make **sqlcmd/bcp** accessible from the bash shell for login sessions, modify your **PATH** in the **~/.bash_profile** file with the following command:
```bash
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
```
To make **sqlcmd/bcp** accessible from the bash shell for interactive/non-login sessions, modify the **PATH** in the **~/.bashrc** file with the following command:
```bash
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
```
## Install tools on Ubuntu 16.04
Use the following steps to install the **mssql-tools** on Ubuntu.
1. Import the public repository GPG keys.
```bash
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
```
1. Register the Microsoft Ubuntu repository.
```bash
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list
```
1. Update the sources list and run the installation command with the unixODBC developer package.
```bash
sudo apt-get update
sudo apt-get install mssql-tools unixodbc-dev
```
> [!Note]
> To update to the latest version of **mssql-tools** run the following commands:
> ```bash
> sudo apt-get update
> sudo apt-get install mssql-tools
> ```
1. **Optional**: Add `/opt/mssql-tools/bin/` to your **PATH** environment variable in a bash shell.
To make **sqlcmd/bcp** accessible from the bash shell for login sessions, modify your **PATH** in the **~/.bash_profile** file with the following command:
```bash
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
```
To make **sqlcmd/bcp** accessible from the bash shell for interactive/non-login sessions, modify the **PATH** in the **~/.bashrc** file with the following command:
```bash
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
```
## Install tools on SLES 12
Use the following steps to install the **mssql-tools** on SUSE Linux Enterprise Server.
1. Add the Microsoft SQL Server repository to Zypper.
```bash
sudo zypper addrepo -fc https://packages.microsoft.com/config/sles/12/prod.repo
sudo zypper --gpg-auto-import-keys refresh
```
1. Install **mssql-tools** with the unixODBC developer package.
```bash
sudo zypper install mssql-tools unixODBC-devel
```
> [!Note]
> To update to the latest version of **mssql-tools** run the following commands:
> ```bash
> sudo zypper refresh
> sudo zypper update mssql-tools
> ```
1. **Optional**: Add `/opt/mssql-tools/bin/` to your **PATH** environment variable in a bash shell.
To make **sqlcmd/bcp** accessible from the bash shell for login sessions, modify your **PATH** in the **~/.bash_profile** file with the following command:
```bash
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
```
To make **sqlcmd/bcp** accessible from the bash shell for interactive/non-login sessions, modify the **PATH** in the **~/.bashrc** file with the following command:
```bash
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
```
## Install tools on macOS
A preview of **sqlcmd** and **bcp** is now available on macOS. For more information, see the [announcement](https://blogs.technet.microsoft.com/dataplatforminsider/2017/05/16/sql-server-command-line-tools-for-macos-released/).
To install the tools for Mac El Capitan and Sierra, use the following commands:
```
/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
#brew untap microsoft/mssql-preview if you installed the preview version
brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
brew update
brew install --no-sandbox mssql-tools
#for silent install:
#ACCEPT_EULA=y brew install --no-sandbox mssql-tools
```
## Docker
Starting with SQL Server 2017 CTP 2.0, the SQL Server command-line tools are included in the Docker image. If you attach to the image with an interactive command-prompt, you can run the tools locally.
## Offline installation
[!INCLUDE[SQL Server Linux offline package installation](../includes/sql-server-linux-offline-package-install-intro.md)]
The following table provides the location for the latest tools packages:
| Tools package | Version | Download |
|-----|-----|-----|
| Red Hat RPM tools package | 14.0.5.0-1 | [mssql-tools RPM package](https://packages.microsoft.com/rhel/7.3/prod/mssql-tools-14.0.5.0-1.x86_64.rpm) |
| SLES RPM tools package | 14.0.5.0-1 | [mssql-tools RPM package](https://packages.microsoft.com/sles/12/prod/mssql-tools-14.0.5.0-1.x86_64.rpm) |
| Ubuntu 16.04 Debian tools package | 14.0.5.0-1 | [mssql-tools Debian package](https://packages.microsoft.com/ubuntu/16.04/prod/pool/main/m/mssql-tools/mssql-tools_14.0.5.0-1_amd64.deb) |
| Ubuntu 16.10 Debian tools package | 14.0.5.0-1 | [mssql-tools Debian package](https://packages.microsoft.com/ubuntu/16.10/prod/pool/main/m/mssql-tools/mssql-tools_14.0.5.0-1_amd64.deb) |
These packages depend on **msodbcsql**, which must be installed first. The **msodbcsql** pacakage also has a dependency on either **unixODBC-devel** (RPM) or **unixodbc-dev** (Debian). The location of the **msodbcsql** packages are listed in the following table:
| msodbcsql package | Version | Download |
|-----|-----|-----|
| Red Hat RPM msodbcsql package | 13.1.6.0-1 | [msodbcsql RPM package](https://packages.microsoft.com/rhel/7.3/prod/msodbcsql-13.1.6.0-1.x86_64.rpm) |
| SLES RPM msodbcsql package | 13.1.6.0-1 | [msodbcsql RPM package](https://packages.microsoft.com/sles/12/prod/msodbcsql-13.1.6.0-1.x86_64.rpm) |
| Ubuntu 16.04 Debian msodbcsql package | 13.1.6.0-1 | [msodbcsql Debian package](https://packages.microsoft.com/ubuntu/16.04/prod/pool/main/m/msodbcsql/msodbcsql_13.1.6.0-1_amd64.deb) |
| Ubuntu 16.10 Debian msodbcsql package | 13.1.6.0-1 | [msodbcsql Debian package](https://packages.microsoft.com/ubuntu/16.10/prod/pool/main/m/msodbcsql/msodbcsql_13.1.6.0-1_amd64.deb) |
To manually install these packages, use the following steps:
1. **Move the downloaded packages to your Linux machine**. If you used a different machine to download the packages, one way to move the packages to your Linux machine is with the **scp** commmand.
1. **Install the and packages**: Install the **mssql-tools** and **msodbc** packages. If you get any dependency errors, ignore them until the next step.
| Platform | Package install commands |
|-----|-----|
| Red Hat | `sudo yum localinstall msodbcsql-13.1.6.0-1.x86_64.rpm`
`sudo yum localinstall mssql-tools-14.0.5.0-1.x86_64.rpm` |
| SLES | `sudo zypper install msodbcsql-13.1.6.0-1.x86_64.rpm`
`sudo zypper install mssql-tools-14.0.5.0-1.x86_64.rpm` |
| Ubuntu | `sudo dpkg -i msodbcsql_13.1.6.0-1_amd64.deb`
`sudo dpkg -i mssql-tools_14.0.5.0-1_amd64.deb` |
1. **Resolve missing dependencies**: You might have missing dependencies at this point. If not, you can skip this step. In some cases, you must manually locate and install these dependencies.
For RPM packages, you can inspect the required dependencies with the following commands:
```bash
rpm -qpR msodbcsql-13.1.6.0-1.x86_64.rpm
rpm -qpR mssql-tools-14.0.5.0-1.x86_64.rpm
```
For Debian packages, if you have access to approved repositories containing those dependencies, the easiest solution is to use the **apt-get** command:
```bash
sudo apt-get -f install
```
> [!NOTE]
> This command completes the installation of the SQL Server packages as well.
If this does not work for your Debian package, you can inspect the required dependencies with the following commands:
```bash
dpkg -I msodbcsql_13.1.6.0-1_amd64.deb | grep "Depends:"
dpkg -I mssql-tools_14.0.5.0-1_amd64.deb | grep "Depends:"
```
## Next steps
For an example of how to use **sqlcmd** to connect to SQL Server and create a database, see one of the following quick start tutorials:
- [Install on Red Hat Enterprise Linux](quickstart-install-connect-red-hat.md)
- [Install on SUSE Linux Enterprise Server](quickstart-install-connect-suse.md)
- [Install on Ubuntu](quickstart-install-connect-ubuntu.md)
- [Run on Docker](quickstart-install-connect-ubuntu.md)
For an example of how to use **bcp** to bulk import and export data, see [Bulk copy data to SQL Server on Linux](sql-server-linux-migrate-bcp.md).