Upgrading the SQL Server to the 2019 or 2022 Version
This chapter presents how to upgrade the SQL server to the 2019 version or 2022 version. Before upgrading, the computer configuration must be checked. The computer must meet all the system requirements for proper function of MS SQL Server 2019 Express.
The upgrade can be done on the following SQL server versions:
- SQL Server 2012 (11.x),
- SQL Server 2014 (12.x),
- SQL Server 2016 (13.x),
- SQL Server 2017 (14.x).
Requirements for the working memory, disc, and processor for all editions of the SQL server are the following:
| Component |
Requirement |
| Hard drive |
6 GB free space |
| Memory (working memory) |
Minimum:
Express Editions: 512 MB
All other editions: 1 GB
Recommended:
Express Editions: 1 GB
Other editions: 4 GB, the increase, according to the growth of the database size, must be calculated |
| Processor speed |
Minimum: x64 Processor: 1.4 GHz
Recommended: 2.0 GHz or faster |
| Processor Type |
x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support |
 |
WARNING
The SQL installation is intended for the x64 bit processor only, x84 bit processors are not supported.
|
Version 2019 - the following requirements apply to all installations.
| Component |
Requirements |
| Operation system |
Windows 10 TH1 1507 or higher
Windows Server 2016 or higher
|
| .NET Framework |
Minimum OS with included .NET Framework |
Version 2022 - the following requirements apply to all installations.
| Component |
Requirements |
| Operation system |
Windows 10 TH1 1607 or higher
Windows Server 2016 or higher
|
| .NET Framework |
SQL Server 2022 (16.x) requires .NET Framework 4.7.2.
|
The user wants to upgrade the SQL server.
 |
HINT
Before upgrading, it is ecessary to back up all databases and applications that use the SQL Server, including PANTHEON, to prevent data loss.
|
For example, we introduce upgrade for SQL server 2019.
First, the user downloads the installation program. The package can be received on the following link: http://go.microsoft.com/fwlink/?linkid=866658.
The user runs the downloaded file. The installation Wizard opens.
If the installation will not be performed immediately, the user selects Custom or Download Media.
The user selects the path of the SQL server installation package on the local hard drive and selects Install.
The installation package download speed depends on internet speed.
When the installation package is downloaded, the SQL server installation can be started.
To upgrade the existing SQL server to SQL Server 2019, the user selects the Upgrade from a previous version of SQL Server option. After a computer scan, the installation offers the instances possible for updating to the latest SQL.
From the list, the user selects the instance that is being upgraded, and continues to the next step.
The user then installs (upgrades) the server.
When the information about successful installation is shown, the computer must be restarted.
After restarting the computer, the upgrade to the latest SQL server version is finished.
|
HINT
After upgrading the SQL server, PANTHEON client continues to work without further intervention.
|