I'm tasked with upgrading several 2008/2014 instances to MSSQL 2019.
Having done many such migrations, I usually build a new VM, install SQL Server and migrate everything over.
But this client wants to do in-place upgrades to keep the same server name so connection strings don't have to be modified. (They do NOT use SPNs, which would eliminate this problem)
Is there a way to migrate to a new VM yet be able to reference the original server name afterwards?