How to change all connections to SQL Server without investigating each hard-coded connection to serverName? We've got a server upgrade scheduled for the near-future and we're looking to move to a new server. Our main issue is that we cannot have two servers with the same name on our domain. So is there a command which corrects all of my connections to '08Server1' from '08Server2' to instead use '16Server1' from '16Server2'?

All our applications also reference '08Serverx' - other than a mass find&amp;replace - is there a better method available?
For our system we set up a DNS Alias and have all the connection strings point at that  i.e. sqlSERVERAlias\Database where SQLSERVERAlias points at 08Serverx or 08Servery  

Then all you've got to do is change the Alias when you change the servers