I have a database server that is about 4 years old. we have a bunch of users that point their applications to this server.
the name of the server is Alpha
We want to upgrade the sql server version from 2012 to 2016. I think i would like to create a new server and do a clean install of sql server instead of doing an in-place upgrade.
So the new server would be bravo...... (if we do not do an in-place upgrade)
isn't it true that if i get the permissions right on bravo and restore all the databases on bravo. that i could thereotically change the name of Alpha to lets say Alpha1 and then rename Bravo to Alpha that the users would not need any configuration changes.
Can someone please verify or send me to a document that outlines the best way to do this.