Process

  1. Detach databases.
  2. Uninstall SQL Server 2014
  3. Install SQL Server 2016/2019
  4. Reattach databases.

Uninstall SQL Server 2014 (v12)

To uninstall SQL Server instance, go to Control Panel and then Programs and Features.

Select and right-click on Microsoft SQL Server 2014 and select Uninstall/remove.

Upgrade to SQL Server 2016 (v13)

SSMS Tool

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

Upgrade to SQL Server 2019 (v15)

SQL Server 2019 Requirements

  • Windows Server 2016 or higher

https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-ver15?view=sql-server-ver15

Sources:

Last modified: March 24, 2020

Author

Comments

Write a Reply or Comment