Can I upgrade from MS SQL server 2019 evaluation edition to SQL 2022 Standard edition? My evaluation period has expired.

Sajin Sathikumar 0 Reputation points
2023-03-24T07:08:03.1866667+00:00

I currently have a 2019 MS SQL server evaluation period installed on my machine. The version passed the expiry and I would like to purchase a license. Wonder if I can purchase a 2022 SQL server standard edition and upgrade my expired evaluation version. Of course, without compromising my database.

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,637 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sedat SALMAN 13,070 Reputation points
    2023-03-24T10:03:44.6633333+00:00

    Yes, you can purchase a SQL Server 2022 Standard Edition license and upgrade your expired SQL Server 2019 Evaluation Edition without compromising your database. To do this, you'll need to perform an edition upgrade to the licensed version using the SQL Server Installation Center.

    1. Make sure you have a backup of your databases before proceeding. Although the upgrade process should not affect your data, it's always a good idea to have a backup in case something goes wrong.
    2. On your machine with the expired SQL Server 2019 Evaluation Edition, insert the SQL Server 2022 installation media or mount the ISO file.
    3. Run the SQL Server Installation Center as an administrator.
    4. Click on the "Maintenance" tab, then select "Edition Upgrade."
    5. In the "Upgrade the Edition for SQL Server" wizard, follow the prompts to proceed with the edition upgrade. When asked for a product key, enter the SQL Server 2022 Standard Edition product key.
    6. Select the instance you want to upgrade, then proceed through the upgrade process. The wizard will guide you through the necessary steps, such as accepting the license terms and performing checks on your system.
    7. Once the edition upgrade is complete, restart your SQL Server services.
    8. Verify the upgrade
    0 comments
  2. Rahul Randive 8,176 Reputation points Microsoft Employee
    2023-03-24T19:20:52.3733333+00:00

    Thanks for your question.

    As per below Microsoft document

    https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2022?view=sql-server-ver16#upgrades-from-earlier-versions-to-sql-server-2022

    The following table lists the supported upgrade scenarios from earlier versions of SQL Server to SQL Server 2022 (16.x).

    User's image

    You can also find tips and tools in the document below which can help you to plan and implement your migration

    https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2022?view=sql-server-ver16#migrate-to-sql-server-2022

    Let us know if this helps or if you have any further question.

    0 comments