How to upgrade microsoft sql server 2019 evaluation to standard edition in ubuntu

Question

What are the steps to be follow upgrade the MSQL Server 2019 Evaluation to Standard Edition in ubuntu 20.04

Answer 1

Hi @Perumal B S

Remove the old repository. Use the following commands based on the type of previously configured repository.

sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-2019.list)"

Configure the new repository to use for SQL Server installations and upgrades.

After you have configured the correct repository, you can proceed to install or update SQL Server and any related packages from the new repository.

Referring from this doc: Configure repositories for installing and upgrading SQL Server on Linux

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi

Before starting the upgrade process, it's crucial to back up your databases to prevent data loss.

First diwnload the SQL Server 2019 Standard Edition installation package from the official Microsoft website.

Stop the SQL Server service to ensure no active connections during the upgrade.

bashCopy code
sudo systemctl stop mssql-server

Uninstall the existing SQL Server packages related to the Evaluation Edition.

bashCopy code
sudo apt-get remove --purge mssql-server

Install the SQL Server 2019 Standard Edition using the downloaded installation package. Follow the installation wizard and provide necessary information.

bashCopy code
sudo dpkg -i <path-to-package.deb>

Follow the documentations below for detailed info

https://learn.microsoft.com/en-us/search/?terms=upgrade%20the%20MSQL%20Server%202019

If this helps kindly accept the answers