[!INCLUDE SQL Server - Linux]

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
• SUSE Linux Enterprise Server
• Ubuntu
• macOS
• Docker

This article describes how to install the command-line tools. If you're looking for examples of how to use sqlcmd or bcp, see the Related content at the end of this article.

These instructions are for installing the [!INCLUDE msconame-md] ODBC 18 packages. For previous versions, see Install the Microsoft ODBC driver for SQL Server (Linux).

[!INCLUDE odbc-redhat]

[!INCLUDE odbc-sles]

[!INCLUDE odbc-ubuntu]

Install Homebrew if you don't have it already:

To install the tools for macOS El Capitan and later versions, use the following commands:

If you run SQL Server in a Docker container, the [!INCLUDE ssnoversion-md] command-line tools are already included in the [!INCLUDE ssnoversion-md] Linux container image. If you attach to a running container with an interactive Bash shell, you can run the tools locally.

If you're creating a container with the [!INCLUDE ssnoversion-md] command-line tools, you should add ACCEPT_EULA=Y to the installation command to silently accept the EULA, and not interrupt image creation. An example final command as part of installation on an Ubuntu-based image is:

[!INCLUDE offline-package-install-intro]

1. First, locate and copy the mssql-tools18 package for your Linux distribution. For Red Hat 8.0, this package is located at https://packages.microsoft.com/rhel/8/prod.

2. Also locate and copy the msodbcsql18 package, which is a dependency. The msodbcsql18 package also has a dependency on unixODBC-devel. For Red Hat, the msodbcsql18 package is located at https://packages.microsoft.com/rhel/8/prod.

3. 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 command.

4. Install the and packages: Install the mssql-tools18 and msodbc18 packages. If you get any dependency errors, ignore them until the next step. Replace <version> with the correct version:

   sudo yum localinstall msodbcsql18-<version>.rpm sudo yum localinstall mssql-tools18-<version>.rpm

5. 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.

   You can inspect the required dependencies with the following commands. Replace <version> with the correct version:

   rpm -qpR msodbcsql18-<version>.rpm rpm -qpR mssql-tools18-<version>.rpm

1. First, locate and copy the mssql-tools18 package for your Linux distribution. For SLES 15, this package is located at https://packages.microsoft.com/sles/15/prod.

2. Also locate and copy the msodbcsql18 package, which is a dependency. The msodbcsql18 package also has a dependency on unixODBC-devel. For SLES, the msodbcsql18 package is located at https://packages.microsoft.com/sles/15/prod.

3. 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 command.

4. Install the and packages: Install the mssql-tools18 and msodbc18 packages. If you get any dependency errors, ignore them until the next step. Replace <version> with the correct version:

   sudo zypper install msodbcsql18-<version>.rpm sudo zypper install mssql-tools18-<version>.rpm

5. 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.

   You can inspect the required dependencies with the following commands. Replace <version> with the correct version:

   rpm -qpR msodbcsql18-<version>.rpm rpm -qpR mssql-tools18-<version>.rpm

1. First, locate and copy the mssql-tools18 package for your Linux distribution. For Ubuntu 20.04, this package is located at https://packages.microsoft.com/ubuntu/20.04/prod/pool/main/m/mssql-tools.

2. Also locate and copy the msodbcsql18 package, which is a dependency. The msodbcsql18 package also has a dependency on unixodbc-dev. For Ubuntu, the msodbcsql18 packages are located at msodbcsql18, and unixodbc-dev.

3. 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 command.

4. Install the and packages: Install the mssql-tools18 and msodbc18 packages. If you get any dependency errors, ignore them until the next step. Replace <version> with the correct version:

   sudo dpkg -i msodbcsql18_<version>.deb sudo dpkg -i mssql-tools18_<version>.deb

5. 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.

   If you have access to approved repositories containing those dependencies, the easiest solution is to use the apt-get command:

   sudo apt-get -f install

   This command completes the installation of the [!INCLUDE ssnoversion-md] packages as well.

   If this step doesn't work for your Debian package, you can inspect the required dependencies with the following commands:

   dpkg -I msodbcsql18_<version>_amd64.deb | grep "Depends:" dpkg -I mssql-tools18_<version>_amd64.deb | grep "Depends:"

• Quickstart: Install SQL Server and create a database on Red Hat Enterprise Linux
• Quickstart: Install SQL Server and create a database on SUSE Linux Enterprise Server
• Quickstart: Install SQL Server and create a database on Ubuntu
• Quickstart: Run SQL Server Linux container images with Docker
• Bulk copy data with bcp to SQL Server on Linux

[!INCLUDE contribute-to-content]