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.
I'm going to back up the DBs and then restore them on the new server. I'll then change the compatibility to Server 2022.
Am I missing anything?
4 Replies
gnussbaum wrote:Am I missing anything?
gnussbaum , several.
For example creating the logins, may existing jobs for backups, maintenance, etc.
Transfer logins and passwords between instances - SQL Server | Microsoft Learn
olafhelper Thank you for this and thank you to everyone else too!
- Definitively you can do backup / restore to move databases from one server to the other.
I'll suggest you do this process in advanced to identify how long it will take the live migration as well as for testing your application(s) with compatibility model 160 and making sure that there are no regressions in performance. Also a good practice is to update statistics after restore is completed
Regards
Javier
Regards
Javier 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
