Towards upgrading SQL 2014 to 2019

Radhai Krish 191 Reputation points
2024-06-08T11:26:56.5266667+00:00

We are brim of making upgrading Windows Server as well as SQL Server.

Currently we are having SQL 2014 RTM, Enterprise Edition in Windows Server 2012 R2

We purchased license for SQL 2022, Enterprise Edition and on process of purchasing license for Windows 2022 DC.

Plan is to upgrade WS 2012 R2 to WS 2019 DC in the first place and then to upgrade the SQL 2014 to SQL 2019. Later towards 2022 in both.

But, as per it is mentioned in MS site, SQL 2014 should be of SP3 in order for it to be supported by WS 2019 DC.

Need assistance in how to proceed with upgrading SQL 2014 RTM to SQL 2014 SP3 within WS 2012 R2. Will direct upgrade to SP3 version would do? Or should we need to install all the CUs and SP1 & SP2 in order to reach SP3? Kindly help us. - Thank you!

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,561 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,181 questions
Windows Server 2012
Windows Server 2012
A Microsoft server operating system that supports enterprise-level management, data storage, applications, and communications.
1,563 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,503 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
62 questions
0 comments
Accepted answer
  1. Erland Sommarskog 105.1K Reputation points MVP
    2024-06-08T15:43:43.1766667+00:00

    You can install Service Pack3 directly. After installation of SP3, I would also recommend that yoy apply CU4 for SP3.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Gowtham CP 3,730 Reputation points
    2024-06-08T16:29:23.4966667+00:00

    Hello Radhai Krish,

    Thanks for reaching out in the Microsoft Q&A!

    To upgrade SQL Server 2014 RTM to SP3, first, ensure you have recent backups of all your SQL Server databases.

    Next, check for any compatibility issues with your applications using Microsoft's documentation.

    Download the SP3 installer from the Microsoft Download Center, making sure to select the correct version for your system.

    Run the installer, choose "Upgrade" during setup, follow the on-screen instructions, and accept the default selections.

    The SP3 installer includes previous updates, so you don't need to worry about them separately.

    After upgrading to SP3, you can migrate to newer versions like Windows Server 2019 and SQL Server 2019, or directly to SQL Server 2022 if your license permits.

    If you need any assistance, feel free to reach out.

    If the response helped, do "Accept Answer" and up-vote it to close the thread! Thanks.

    1 person found this answer helpful.
    0 comments