PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Expand]Guide for PANTHEON
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Collapse]User Manual for PANTHEON
   [Collapse]Getting Started
     First steps with PANTHEON
    [Expand]PANTHEON Installation
    [Expand]PANTHEON Basics
    [Collapse]PANTHEON System data
     [Expand]PANTHEON System data
     [Collapse]MS SQL Server
       Download and install MS SQL Server
       Upgrading the SQL Server to the newer version
       MS Management Studio - Download and install
       Restoring database onto SQL server
       Adding users to server level (AddUser_PAX)
       Installing SQL for external access
       Installing PANTHEON clients
      [Expand]MS SQL Server Security
      [Expand]Useful SQL Queries
       SQLExecute
      [Expand]SQL Server Jobs
     [Expand]Microsoft Windows Utilities
     [Expand]Security Policy
     [Expand]Database Administration
    [Expand]PANTHEON Security
    [Expand]Using PANTHEON at Tecta, a fictional company
    [Expand]Frequently asked questions about Pantheon (F.A.Q.)
   [Expand]User Manual for eBusiness
   [Expand]Settings
   [Expand]Orders
    Creating new invoice
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]Service
   [Expand]Help
   [Expand]Personnel
   [Expand]Financials
   [Expand]Analytics
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
[Expand]User Site

Load Time: 2046.8912 ms
"
   1000002884 | 222486 | 375240 | Updated
Label

Upgrading the SQL Server to the newer version

This chapter explains how to upgrade the SQL Server to a newer version, for example from SQL Server 2019 to SQL Server 2022.
Before upgrading, versions upgrade compatibility and hardware and software requirements must be checked.
All requirements must be met for a successful upgrade to a newer version of Microsoft SQL Server.

Table of contents

  1. Upgrade compatibility
  2. Hardware and software requirements
  3. Upgrading

1. Upgrade compatibility


At the following links, you can check the upgrade compatibility data for individual versions of Microsoft SQL Server:

Microsoft SQL Server 2017
Microsoft SQL Server 2019
Microsoft SQL Server 2022
Microsoft SQL Server 2025

2. Hardware and software requirements

This article lists the minimum hardware and software requirements to install and run SQL Servers:
Microsoft SQL Server 2017
Microsoft SQL Server 2019
Microsoft SQL Server 2022
Microsoft SQL Server 2025

3. Upgrading

The user wants to upgrade the Microsoft SQL server to a newer version 2022.

HINT
  • Before upgrading, it is necessary to back up all databases and applications that use the SQL Server, including PANTHEON, to prevent data loss.
  • Installation packages for all SQL versions can be found on Microsoft web page.

First, the user downloads the Microsoft SQL server 2022 installation package.

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.

 

RELATED TOPICS:

Computer Configuration

Changing PANTHEON Version

Installation Process

On-Premises Installation

 

 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!