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.
What is the best approach to perform inplace upgrade first . is it OS or SQL ?
Durga Tota
0
Reputation points
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.
1 answer
Sort by: Most helpful
-
Erland Sommarskog 128.6K Reputation points MVP Volunteer Moderator2025-08-07T21:45:53.6533333+00:00