Skip to content

Latest commit

 

History

History
85 lines (60 loc) · 6.29 KB

sql-server-linux-overview.md

File metadata and controls

85 lines (60 loc) · 6.29 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom
Overview of SQL Server on Linux
This article describes how SQL Server runs on Linux and provides information on how to learn more.
rwestMSFT
randolphwest
11/18/2024
sql
linux
concept-article
linux-related-content

What is SQL Server on Linux?

[!INCLUDE SQL Server - Linux]

::: moniker range="=sql-server-2017 || =sql-server-linux-2017" Starting with [!INCLUDE sssql17-md], [!INCLUDE ssnoversion-md] runs on Linux. It's the same [!INCLUDE ssdenoversion-md], with many similar features and services regardless of your operating system.

Tip

SQL Server 2019 is available! To find out what's new for Linux in the latest release, see What's new in SQL Server 2019 for Linux. ::: moniker-end

::: moniker range="=sql-server-ver15|| =sql-server-linux-ver15" [!INCLUDE sssql19-md] runs on Linux. It's the same [!INCLUDE ssdenoversion-md], with many similar features and services regardless of your operating system. To find out more about this release, see What's new for SQL Server 2019 on Linux.

Tip

SQL Server 2022 is available! To find out what's new for Linux in the latest release, see What's new in SQL Server 2022. ::: moniker-end

::: moniker range=">= sql-server-ver16 || >= sql-server-linux-ver16" [!INCLUDE sssql22-md] runs on Linux. It's the same [!INCLUDE ssdenoversion-md], 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 2022.

::: moniker-end

Install

To get started, install [!INCLUDE ssnoversion-md] on Linux using one of the following quickstarts:

Container images

The [!INCLUDE ssnoversion-md] container images are published and available on the Microsoft Container Registry (MCR), and also cataloged at the following locations, based on the operating system image that was used when creating the container image:

Note

Containers will only be published to MCR for the most recent Linux distributions. If you create your own custom [!INCLUDE ssnoversion-md] container image for an older supported distribution, it will still be supported. For more information, see Upcoming updates to SQL Server container images on Microsoft Artifact Registry aka (MCR).

Connect

After installation, connect to the [!INCLUDE ssnoversion-md] instance on your Linux machine. You can connect locally or remotely and with various 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) SQL Server extension for Visual Studio Code
SQL Server Management Studio (SSMS) Use SQL Server Management Studio on Windows to manage SQL Server on Linux
SQL Server Data Tools (SSDT) Use Visual Studio to create databases for SQL Server on Linux

Explore

Starting with [!INCLUDE sssql17-md], [!INCLUDE ssnoversion-md] has the same underlying [!INCLUDE ssde-md] on all supported platforms, including Linux and containers. Therefore, many existing features and capabilities operate the same way. 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're already familiar with [!INCLUDE ssnoversion-md] on Linux, review the release notes for general guidelines and known issues for this release:

Then look at what's new:

Tip

For answers to frequently asked questions, see the SQL Server on Linux FAQ.

[!INCLUDE Get Help Options]