March 13, 2022 at 5:20 pm
Hey Everyone, My project wants to upgrade their sql server 2014 SP3 to newest one. I am not sure if I should pick sql server 2017 or just go with the latest 2019 version. The databases we use is not very bulky and we have 12 databases in the production environment. Shall I just upgrade to 2017 now and wait to see how 2019 goes in future https://tutuappx.com/? Thanks
March 13, 2022 at 8:47 pm
Upgrade to 2019 if time is of the essence.
SQL2022 is just around the corner. So if you can hold off till the end of the year, I would wait and upgrade to 2022.
2017 drops out of mainstream support in July, so I would advocate for 2019 wherever possible, 2022 if you can wait.
March 14, 2022 at 2:56 pm
Just to counter-point Ant-Green's suggestion of 2019/2022, I would review what OS version you are on and make sure that the SQL version you upgrade to is supported at the OS level. I had planned to upgrade my systems to 2019, but the OS is too old for 2019 to be supported and the whole point of the upgrade was to get things into a supported structure. That being said, the OS and 2017 are going to be out of support soon, so I will need to upgrade the OS and the instances again soon, but changing OS's is a bit of a project and not something that can be done safely in a few days especially since I need downtime on the instances for it. THANKFULLY I have some failover software in place, so I can simply get the new servers set up as a secondary and then force a failover on a weekend and I should be good to go.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 14, 2022 at 9:41 pm
Brian brings up a good point, but as he noted, the OS ought to be upgraded as well.
Since SQL 2019/2017/2016 cost the same (2019 rates), I would always choose the latest version. If you aren't in a hurry, I would be trying to delay and consider 2022 later this year. I don't know if it will cost more, but likely not a lot more and will be supported for a long time.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply