I've got an old apps, which is pointing a database on a named instance SQL e.g. servername1\instancename.
as part of consolidation, I needed to move the database into a new server with default instance e.g. servername2.
as this is an old apps, the only way to re-point the database is by re-installing, and we want to avoid this.
is there away, where i can use alias/a pointer/an name or other in order to point the apps to the new server (without instance name)?
Thanks in advanced.