How to Upgrade SQL Server 2016 to SQL Server 2019 without Reinstalling

Upgrades from earlier versions to SQL Server 2019 (15.x)

SQL Server 2019 (15.x) supports upgrade from the following versions of SQL Server:

SQL Server 2012 (11.x) SP4 or later
SQL Server 2014 (12.x) SP2 or later
SQL Server 2016 (13.x) SP2 or later
SQL Server 2017 (14.x)

Operating System support for SQL Server 2019

Windows 10 TH1 1507 or greater.
Windows Server 2016 or greater.

Upgrade the existing SQL 2016 instance to SQL 2019

Upgrade the existing instance to SQL 2019 – specially for the other databases for other projects on the same server instance. Be certain, you are running SQL Server 2016 with Service Pack 2 (SP2) or later. How to Download and Install a Service Pack for SQL Server.

For SQL Server 2008, and SQL Server 2008 R2, you’ll either need to do a side-by-side upgrade, or a migration, to move to SQL Server 2019 as there is no common overlap between a supported mainstream operating system. How to Upgrade SQL Server 2008 to SQL Server 2016 without Reinstalling

In-Place Upgrade from SQL Server 2016 to SQL Server 2019

1. Download SQL Server 2019 iso image then mount it into your server. Open up setup.exe of the SQL Server 2019 media.

2. Select Upgrade from a previous version of SQL Server in the Installation tab.

3. Select the Enter the product key option and type the product key if the product key is not filled automatically.

4. At Select Instance, select the instance of the SQL server that you want to upgrade.

5. Select Features to be upgrade.

In the Ready to Upgrade screen, the list of upgrade and installation criteria will be displayed. Click Upgrade to start the upgrade and installation.

Once the installation has completed successfully, the installed components will be displayed with a green icon.