Greetings everyone!
I am currently prepping for a migration to a new server and version. I am going through this guide and step 8 is to run a query to update the NETBIOS short name in a couple tables to the new server.
Can we use an alias that points to the correct name/IP instead of the actual NETBIOS name of the server? For example if the old server is OrionOLD and the new one is OrionNEW and we have an alias in DNS and NETBIOS of just Orion that points at the OrionNEW server can we update the DB with just the Orion name so it wont be required to make DB changes in the future?
Additionally I see the Engines table has entries for IP Address as well as ServerName. Does this "IP Address" field need to be updated as well as the ServerName, or will it update as soon as it resolves the new name? We are planning on changing the servers IP to match the old one so we probably don't need to worry about it, but it will be good to know just in case.
Thanks!