The system requirements are the following for SQL Server 2019 on Linux platforms : These 2 tests will show if it is easy to migrate from SQL Server 2016 on Windows to SQL Server 2019 on Linux.

Export/import a table with bcp in native mode from SQL Server 2016 Windows to SQL Server 2019 Linux.

Restore a database on Linux SQL Server 2019 from a windows SQL Server 2016 database backup.SQL Server agent, SSL and active directory authentication are not covered here.Īfter the installation, the 2 first tests performed will be :.Database files are not installed in the default directory.The SQL Server engine listens on port 1433 and runs with the user mssql.As almost companies implement firewall rules that prevent serversįrom communicating with the outside world, offline installations are performed with the packages *.deb provided by Microsoft. In this article, a standalone SQL Server instance is installed.

Multiples instances and named instances are not (yet ?) supported on Linux platforms, third party architectures like Docker must be used SQL Server 2019 is installed on Ubuntu 18.04 in this article : only Ubuntu 16.04 is supported, but it works on Ubuntu 18.04 for test purposes.

So let’s explore SQL Server 2019 on Linux. SQL Server 2019 on Linux platforms now include the major missing features in SQL Server 2017. Some active directory authentication mechanisms and SQL Server agent functionalities… List of SQL Server 2017 missing features on Linux. High avalaibility and mirroring, distributed transaction coordinator (DTC), SQL Server 2017 was already supported on Linux platforms, but many features were missing compared to Windows version like replication, Definitely not the author of this article, but Microsoft did it ! Who would have believed in 2009, ten years ago, Microsoft SQL Server 2019 on Linux Platforms.

For windows instal EF Commander 2023.07