Hi @15431565
You can refer to this official document.
Best regards,
Percy Tang
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
SQL Server on my computer is the 2014 version and now I plan to upgrade it to the 2019 version.
What I'm asking is: How should I migrate my user database to the new SQL Server?
Thanks in advance!
Answer accepted by question author
Adding to Olaf's answer:
For an in-place upgrade you need to consider the OS support. SQL 2019 may not be running on your current OS, and in that case, you may no choice but to move to a new machine.
Migrating the user databases as such is straightforward, as you can do this with BACKUP/RESTORE. Migrating logins, jobs etc takes some manual work.
Whichever path you take - in-place or move to a new instance - you should be prepared for performance regressions. They can occur with some bad luck. So do this: once you have SQL 2019 in place, enable Query Store for all your databases, but keep the compatbility level at the current level. Once you have been in production for a while, a week or two, switch to compatibility level 150. The kicker is this: if a query now starts to be slow, you can force the old plan with Query Store.
In SSMS there is specific support for this scenario. Right-click a database and at the bottom of the context menu, you find Database Upgrade.
How should I migrate my user database to the new SQL Server?
Which upgrade method have you in mind:
For migrating your database you should follow these steps:
I hope this would help you!!