| title | Overview of SQL Server on Linux |
|---|---|
| description | This article describes how SQL Server runs on Linux and provides information on how to learn more. |
| author | VanMSFT |
| ms.author | vanto |
| manager | jroth |
| ms.date | 04/23/2019 |
| ms.topic | conceptual |
| ms.prod | sql |
| ms.technology | linux |
| ms.assetid | 9dcc6a90-0add-42c2-815b-862e4e2a21ac |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-linuxonly]
::: moniker range="= sql-server-2017 || = sqlallproducts-allversions" Starting with SQL Server 2017, SQL Server runs on Linux. It's the same SQL Server database engine, with many similar features and services regardless of your operating system. ::: moniker-end
::: moniker range=">= sql-server-ver15 || >= sql-server-linux-ver15" SQL Server 2019 preview runs on Linux. It's the same SQL Server database engine, with many similar features and services regardless of your operating system. To find out more about this release, see What's new in SQL Server 2019 preview for Linux. ::: moniker-end
::: moniker range="= sql-server-2017"
Tip
SQL Server 2019 preview has been released! To find out what's new for Linux in the latest release, see What's new in SQL Server 2019 preview for Linux. ::: moniker-end
::: moniker range="= sql-server-linux-2017"
Tip
SQL Server 2019 preview has been released! To find out what's new for Linux in the latest release, see What's new in SQL Server 2019 preview for Linux. ::: moniker-end
::: moniker range="= sqlallproducts-allversions"
Tip
SQL Server 2019 preview has been released! To find out what's new for Linux in the latest release, see What's new in SQL Server 2019 preview for Linux. ::: moniker-end
To get started, install SQL Server on Linux using one of the following quickstarts:
- Install on Red Hat Enterprise Linux
- Install on SUSE Linux Enterprise Server
- Install on Ubuntu
- Run on Docker
- Provision a SQL VM in Azure
Note
Docker itself runs on multiple platforms, which means that you can run the Docker image on Linux, Mac, and Windows.
After installation, connect to the SQL Server instance on your Linux machine. You can connect locally or remotely and with a variety of tools and drivers. The quickstarts demonstrate how to use the sqlcmd command-line tool. Other tools include the following:
| Tool | Tutorial |
|---|---|
| Visual Studio Code (VS Code) | Use VS Code with SQL Server on Linux |
| SQL Server Management Studio (SSMS) | Use SSMS on Windows to connect to SQL Server on Linux |
| SQL Server Data Tools (SSDT) | Use SSDT with SQL Server on Linux |
::: moniker range="= sql-server-linux-2017 || = sql-server-2017"
SQL Server 2017 has the same underlying database engine on all supported platforms, including Linux. Therefore, many existing features and capabilities operate the same way on Linux. This area of the documentation exposes some of these features from a Linux perspective. It also calls out areas that have unique requirements on Linux.
If you are already familiar with SQL Server, review the Release notes for general guidelines and known issues for this release. Then look at what's new for SQL Server on Linux as well as what's new for SQL Server 2017 overall.
::: moniker-end
::: moniker range=">= sql-server-linux-ver15 || >= sql-server-ver15"
[!INCLUDESQL Server 2019] has the same underlying database engine on all supported platforms, including Linux. Therefore, many existing features and capabilities operate the same way on Linux. This area of the documentation exposes some of these features from a Linux perspective. It also calls out areas that have unique requirements on Linux.
If you are already familiar with SQL Server on Linux, review the Release notes for general guidelines and known issues for this release. Then look at what's new for SQL Server 2019 preview on Linux.
::: moniker-end
::: moniker range="=sqlallproducts-allversions"
SQL Server 2017 and [!INCLUDESQL Server 2019] have the same underlying database engine on all supported platforms, including Linux. Therefore, many existing features and capabilities operate the same way on Linux. This area of the documentation exposes some of these features from a Linux perspective. It also calls out areas that have unique requirements on Linux.
If you are already familiar with SQL Server on Linux, review the release notes:
Then look at what's new:
::: moniker-end
Tip
For answers to frequently asked questions, see the SQL Server on Linux FAQ.
[!INCLUDEGet Help Options]
[!INCLUDEcontribute-to-content]