Breadcrumbs

Upgrade Microsoft SQL Server Express 2014 to 2019

Before upgrading the old Microsoft SQL Server Express 2014 to 2019, please stop all VMS services.


To Upgrade Microsoft SQL Server Express 2014 to 2019 please proceed as follows:

  1. Download the latest Microsoft SQL Server Express 2019 installer from the Microsoft site.

    image-20230404-104730.png


  2. Open the Microsoft download tool by double-clicking the downloaded exe file.

    image-20230404-104815.png


  3. Click the Download Media button.

  4. In the next window, select Express Advanced installation package and download location.

    1. When the download is ready, you can proceed to upgrade.

      image-20230404-104900.png


  5. Double-click the installation media, and after this, it will extract files

  6. When this is done, you should see a new window where the option is to “Upgrade from a previous version of SQL Server.”

    image-20230404-105033.png


  7. Click that option and wait.

  8. Accept the license agreement.

    image-20230404-105119.png


  9. If there are undone tasks, this next window will show those. This only shows if there is something wrong before the upgrade.

  10. On default, the system offers the current SQLEXPRESS instance upgrade. Click Next to proceed.

    image-20230404-105229.png


  11. After this, the wizard starts the upgrade process. Please wait. It will take some time until it is finished.

    image-20230404-105328.png


  12. When the installation is finished, you can check the status of the installation, and if that is succeeded, you can close the window using the Close button.

    image-20230404-105435.png


  13. After this, you can close the installer window using the upper right corner X.

    image-20230404-105531.png


  14. Now, the Microsoft SQL Express 2014 to 2019 upgrade is done.

  15. You can now start VMS services or restart the server.

Using SQL Management Studio, you can check the SQL Express version number.

image-20230404-105658.png