Forum Discussion
Moving a SQL Server 2017 database to SQL Server 2022
Hello, I've been tasked with moving some SQL Server 2017 databases to a new SQL 2022 server as we are retiring our old one. I believe it's pretty straightforward but want to ask just in case. ...
Hi, George.
The backup and restore approach is fine.
Changing the compatibility mode is a separate topic though and isn't related to moving the database.
To minimise risk, you would not change the compatibility mode - at least not without sufficient testing.
Cheers,
Lain