Our production server is currently running SQL Enterprise 2017.
We’re paying for software assurance which means we can upgrade at any time.
Should we be looking at SQL 2019?
Below are the methods you can try. The first solution is probably the best. Try others if the first one doesn’t work. Senior developers aren’t just copying/pasting – they read the methods carefully & apply them wisely to each case.
Don’t upgrade just for the sake of upgrading. Upgrade if there are enhancements or features that you’ll get meaningful benefit from.
2017 enters Extended Support later this year, but 2022 will be released this year as well. It’s probably better to let 2022 come out, see how solid a release it is (are there major bugs fixed in the first few CUs?), and then consider your options between 2019 & 2022.
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0