How to transfer the MS SQL database to another server so that the client connection remains unchanged?

Question

Database

Good afternoon!
AVAILABLE:

1. Server with MS SQL 2008 Express, on which the DB01 database is located. Server Name: Server01 Named Instance Name: SQL2008EXPRESS
   
2. Server with MS SQL 2008 R2 where you want to transfer the database. Server name: Server02, default instance name : MSSQLSERVER
   
3. Client database connections ( named instance ):
   Server name: Server01\SQL2008EXPRESS
   DB name: DB01
   DB schema: dbo
   

NEEDED:
Transfer the DB01 database from Server01 to an already existing Server02 with default initialization to a full-fledged MS SQL and so that the configuration file with the database connection settings does not change for users. Can you please give me some suggestions or ideas on how to solve this problem?
Changing configs on the user side using GPOs, etc. are not considered.

Answer 1

Answer: It is
not necessary to install the SQL native client in Windows, starting from 2000, there is a regular MSSQL client.
Writing to the client registry worked, for a 32-bit application:
for xp:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo]
"Server01\\SQL2008EXPRESS"="DBMSSOCN,Server02,1433"

for win7+:

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\ConnectTo]
"Server01\\SQL2008EXPRESS"="DBMSSOCN,Server02,1433"

Answer 2

You raise a named instance with the same name as the old server on Server02, transfer the database there, rename the server to Server01. Otherwise, just edit the client configs.

Answer 3

And then it turns out that half of the connections are not by name, but by ip )
In principle , Maxim Grishin described a possible crutch option ...
ps I would also add electrical tape to these crutches: create a fiction_sql_server entry in dns / hosts pointing to the current server and that's it -we edit all connections to fiction_sql_server\sql2008express. After the connection is established and stable, we change the address in dns to the address of the new server and profit