I know the subject line question is tricky and twisty to respond, and not easy to handle the upgrade situation for legacy database applications.
When I say tricky in the sense of getting an approval from the management to upgrade previous versions of SQL Server (as of now 7[!], 2000 and 2005 versions). The easy option to let the Management agree to the terms is:
- Not supported by Microsoft
- No bug fixes or security fixes, once the version is out of mainstream & extended support
- Unable to use productivity features
Not just the Management approval, another major hurdle is code dependency or unsupported third-party tools/applications.
Well to overcome some part of this problem Microsoft’s SQL Server Engineering team wants to work directly with you, to improve the SQL Server upgrade and migration experience!
If interested, please complete this brief survey about your SQL Server usage and our team will reach out to you via email to set up a 30-minute phone call at your convenience. We look forward to talking to you and hearing your valuable feedback!
Click this Upgrade Help Survey link.