Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
893 views
in Announcements by 152 169 345

On Jan 9, 2020, Microsoft has announced the SQL Server 2019 starting with Cumulative Update 1 is now generally available and fully supported for production use on Red hat Enterprise Linux 8.

SQL Server on Red Hat Enterprise Linux 8

Additionally, SQL Server 2019 CU1 container image build on Redhat UBI8 is now available and supported for use on production. 

For more details about SQL Server 2019 CU1 container, Please, check the details at Docker Hub.


Update SQL Server 2019 on Red hat Enterprise Linux 8

Update SQL Server 2019 on Redhat Enterprise Linux 8

First of all, you must have the Cumulative Update repository configured, to be able to update SQL Server 2019 on Linux to the latest CU!

Then, you should run the below update command:

sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/8/mssql-server-2019.repo

You may be also interested to check Microsoft Products Monthly Announcements | Dec 2019


Why do I need to configure Microsoft Repository?

Without Microsoft Repository, you will not get database engine package, "mssql-server" and its related SQL Server Packages. therefore, you will not be able to install SQL Server on Linux.

What're the types of repositories?

There are two main types of repositories:

  • Cumulative Update.
  • GDR.

What's the Cumulative Update (CU) Repository?

It contains packages for the base release, any bug fixes and enhancements since this release.

What's the GDR Repository?

It contains packages for the base release, security updates, and only the critical bug fixes since this release.

Is it supported to update from GDR to Cumulative Update?

Yes, it's supported.

By changing the configured repository you can update from GDR to CU.

Is it supported to update from Cumulative Update to GDR?

No, It's not supported.


Create a new repository

SQL Server 2019 CU Repository

sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/8/mssql-server-2019.repo

SQL Server 2019 GRD Repository

sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/8/mssql-server-2019-gdr.repo

Note: As a prerequisite for SQL Server on Linux, the Python2 should be preinstalled. but In Red Hat Enterprise Linux 8, the python2 is not preinstalled. 

After configuring the repository, you can go ahead to install or update SQL Server from the newly created repository.

For more details, Please check Installation guidance for SQL Server on Linux.

Check configured repository

sudo ls /etc/yum.repos.d
sudo cat /etc/yum.repos.d/mssql-server name.repo

Remove existing repository

sudo rm -rf /etc/yum.repos.d/mssql-server name.repo

Reference

See also


If you don’t ask, the answer is always NO!
...