Redigera

Dela via


What's new for SQL Server 2019 on Linux

Applies to: SQL Server 2019 (15.x) - Linux

This article describes the major features and services available for SQL Server 2019 (15.x) running on Linux. For package downloads and known issues, see the Release notes.

SLES 15 supported

Starting with SQL Server 2019 (15.x) CU 14, SLES 15 is now supported. Check out our Quickstart on Installing SQL Server and creating a database on SUSE Linux Enterprise Server.

Ubuntu 18.04 and 20.04 supported

RHEL 8 supported

Starting with SQL Server 2019 (15.x) CU 1, RHEL 8 is now supported. Check out our Quickstart on Installing SQL Server and creating a database on Red Hat.

Updates

The updates have been made in SQL Server 2019 (15.x) on Linux:

New feature or update Details
Replication support SQL Server Replication on Linux
Support for the Microsoft Distributed Transaction Coordinator (MSDTC) How to configure MSDTC on Linux
OpenLDAP support for third-party Active Directory providers Tutorial: Use Active Directory authentication with SQL Server on Linux
Machine Learning on Linux Configure Machine Learning on Linux
tempdb improvements By default, a new installation of SQL Server on Linux creates multiple tempdb data files based on the number of logical cores (with up to 8 data files). This does not apply to in-place minor or major version upgrades. Each tempdb file is 8 MB with an auto growth of 64 MB. This behavior is similar to the default SQL Server installation on Windows.
PolyBase on Linux Install PolyBase on Linux for non-Hadoop connectors.

PolyBase type mapping.
Change Data Capture (CDC) support Change Data Capture (CDC) is now supported on Linux for SQL Server 2019 (15.x).
Microsoft Container Registry The Microsoft Container Registry replaces Docker Hub for official Microsoft container images, including SQL Server.
Non-root containers SQL Server 2019 (15.x) introduces the ability to create safer containers by starting the SQL Server process as a non-root user by default. See build and run SQL Server containers as a non-root user for more details.

To install SQL Server on Linux, use one of the following tutorials:

For answers to frequently asked questions, see the SQL Server on Linux FAQ. To see other improvements introduced in SQL Server 2019 (15.x), see What's new in SQL Server 2019.

Get help

Contribute to SQL documentation

Did you know that you can edit SQL content yourself? If you do so, not only do you help improve our documentation, but you also get credited as a contributor to the page.

For more information, see How to contribute to SQL Server documentation