What's new for SQL Server 2019 on Linux

APPLIES TO: yesSQL Server (Linux only) noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

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

Updates

The updates have been made in SQL Server 2019 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 AD 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.
Microsoft Container Registry The Microsoft Container Registry now replaces Docker Hub for new official Microsoft container images, including SQL Server 2019 (15.x).
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.

Next steps

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, see What's New in SQL Server 2019.

info_tip Get help