Share via

upgrade of SQL Server

Fake1 20 Reputation points
2023-11-17T07:40:12.5833333+00:00

Hello.

At present, the latest version of SQL Server has reached 2022. The version of SQL Server on my computer is a bit outdated.

I'm planning an upgrade of SQL Server in the next few days. I am planning to upgrade to 2019, pls what points should I pay attention to? Can you give me some advice?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,118 questions
0 comments
Accepted answer
  1. PercyTang-MSFT 12,501 Reputation points Microsoft Vendor
    2023-11-17T07:47:06.5633333+00:00

    Hi @Fake1

    First, you need to confirm that you meet the SQL Server 2019: Hardware and Software requirements.

    https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-2019?view=sql-server-ver16

    Do not forget to backup all databases before starting an upgrade.

    For more details, you can refer to this official link.

    https://learn.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-sql-server?view=sql-server-ver16

    Best regards,

    Percy Tang

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. RahulRandive 9,901 Reputation points
    2023-11-18T00:36:28.4466667+00:00

    Hi @Fake1

    Here is the pre-upgrade checklist

    • Before upgrading from one edition of SQL Server to another, verify that the functionality you're currently using is supported in the edition to which you're moving.
    • Verify supported hardware and software.
    • Before upgrading SQL Server, enable Windows Authentication for SQL Server Agent and verify the default configuration, that the SQL Server Agent service account is a member of the SQL Server sysadmin group.
    • To upgrade to SQL Server 2019 (15.x), you must be running a supported operating system. For more information, see Hardware and Software Requirements for Installing SQL Server.
    • Upgrade will be blocked if there's a pending restart.
    • Upgrade will be blocked if the Windows Installer service isn't running.

    Below are the unsupported scenarios

    • Cross-version instances of SQL Server 2019 (15.x) aren't supported. Version numbers of the Database Engine components must be the same in an instance of SQL Server 2019 (15.x).
    • SQL Server 2019 (15.x) is only available for 64-bit platforms. Cross-platform upgrade isn't supported. You can't upgrade a 32-bit instance of SQL Server to native 64-bit using SQL Server Setup.
    • You can't add new features during the upgrade of your existing instance of SQL Server. After you upgrade an instance of SQL Server to SQL Server 2019 (15.x)

    Please note,

    SQL Server 2019 (15.x) supports upgrade from the following versions of SQL Server:

    • SQL Server 2012 (11.x) SP4 or later
    • SQL Server 2014 (12.x) SP2 or later
    • SQL Server 2016 (13.x) RTM or later
    • SQL Server 2017 (14.x)

    Let us know if you need any additional information.

    Thank you!

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.