May 11 2022 02:05 AM
how to upgrade sql server 2016 to 2019 on azure platform?
I would appreciate if I get step by step info including pre and post checkouts
Thanks.
May 11 2022 02:48 AM
@MayurS21 , with Azure Platform do you mean a virtual machine (VM) on Azure?
Then the upgrade is the same as on-premise; install the new version.
May 11 2022 07:44 AM
May 11 2022 10:19 PM
SolutionJun 20 2022 05:42 AM
Hi @MayurS21
Obviously @olafhelper is correct but!
> Can I perform in place upgrade same like on premise?
Not everything you can, you should!
For most cases, I HIGHKLY recommend NOT to upgrade an active server from one version to the other. Instead use rare opportunity to have a clean system which is best designed according to the experience you now have after years of working with the databases.
You can start with files in the right size which can improve performance over files which where grew gradually (this mean that you can control the number of VLF for example), you can use the knowledge which you have now to better plan the configuration of the server, you can sue the history to know what is the best number of files you need for the tempdb for example, and any more...
Not every day you want to use a new version! Take advantage of the opportunity
May 11 2022 10:19 PM
Solution