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