Share via

What is the best approach to perform inplace upgrade first . is it OS or SQL ?

Durga Tota 0 Reputation points
2025-08-07T10:32:00.48+00:00

Current OS ( 2016)and SQL (2016) versions are going to obsolete and user wants to do inplace upgrade both OS and SQL to version 2022 .

What is the best approach to perform inplace upgrade first . is it OS or SQL ?

Could you please provide me the step by step document .

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.
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
    2025-08-07T21:45:53.6533333+00:00

    I think both order will work, but I would update SQL Server first. Make sure that you take backups of the databases both before you upgrade to SQL 2022 and before you upgrade the OS. It the machine is a virtual machine, by all means make sure that you have a backup/snapshot of the machine before you start.

    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.