Share via

Upgrade SQL Server 2019 (Standard Edition) to SQL Server 2022 (Standard Edition)

kanav sharma 5 Reputation points
2023-12-13T15:08:07.2733333+00:00

I want to upgrade my production SQL Server (2019 Standard Edition) version to SQL Server 2022(Standard Edition) which is hosted on the Azure virtual machine. There are 400-500 databases currently running on the SQL server 2019. So also want to migrate all databases to SQL Server 2022. I just want to know how I can achieve this. Please help me as soon as possible like how can I achieve this task. Provide me detail solution regarding the same!

Thank you.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,869 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,821 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,464 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
495 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,249 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,326 Reputation points Microsoft Vendor
    2023-12-14T02:43:13.7333333+00:00

    Hi @kanav sharma

    Do you want to migrate your local SQL Server to SQL Server on an Azure virtual machine? Or move to Azure SQL Managed Instance?

    This link provides most of the database migration guide: https://learn.microsoft.com/en-us/data-migration/, maybe you can use it as a reference.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

    0 comments
  2. Erland Sommarskog 102.2K Reputation points
    2023-12-14T19:49:43.1+00:00

    Two options:

    1. You make an in-place upgrade. You simply download the iso, start Setup and select the Upgrade alternative. See image below.
    2. You create a new VM with SQL 2022 and move all the databases with BACKUP/RESTORE.

    The advantage with the latter is that you can keep the old version as a reference if there is a performance regression, or there are some other issue. On the other hand, the first option is simpler, not the least given the number of databases. If you go for an in-place upgrade, make sure that you have a snapshot or similar of the VM that you can revert to, in case there is an unexpected error.

    I'm assuming here that you have an OS that SQL 2022 supports. Windows Server 2019 should be OK. I am not sure about Windows Server 2016.

    User's image

    0 comments