Upgrade SQL Server to version 2019
We will describe an example of upgrading SQL Server to version 2019. Before upgrading, it is necessary to check the configuration of the computer. It is necessary that the computer meets the system requirements for normal operation of MS SQL Server 2019 Express.
The upgrade can be performed 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).
Table of contents
- System requirements
- Programme requirements
- Upgrade
|
1. System requirements
The working memory, disk and processor requirements for all editions of SQL Server are the same:
| Component |
Request |
| Hard disk |
6 GB free space |
| Memory (working memory) |
Minimum:
Express Editions: 512 MB
All other editions: 1 GB
Recommended:
Express Editions: 1 GB
Other versions 4 GB, must be calculated in order to allow for growth in database size |
| 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 Server installation is designed for x64 bit processors only, x84 bit processors are not supported.
|
2. Programme requirements
| Component |
Requirements |
| Operating system |
Windows 10 TH1 1507 or higher
Windows Server 2016 or higher
|
| .NET Framework |
Minimum OS with .NET framework included |
3. Upgrading
A user wants to upgrade SQL Server.
In the first step, it downloads the installation package. You can download the package from the following link: go.microsoft.com/fwlink/?linkid=866658.
The user starts the downloaded file. The installation wizard opens.
Choose Custom or Download Media if you don't want to start the installation right away.
Select the location of the SQL Server installation package on your local hard disk and select Install.
The download speed of the installation package depends on the speed of your internet connection.
Once the installation package has been downloaded, we can start the SQL Server installation.
To upgrade an existing SQL Server to SQL Server 2019, the user selects the Upgrade from a previus version of SQL Server option. After scanning the computer, the installation offers the instances that are available for upgrade to the latest SQL.
From the list, the user selects the instance to upgrade and proceeds to the next step.
This is followed by the installation (update) of the server.
When we are informed that the installation has been successful, we will need to restart the computer.
After the reboot, we finished the upgrade to the latest version of SQL Server.
 |
HINT
The PANTHEON client continues to run after the SQL Server upgrade without further intervention.
|