Migrating App Portal DB to another SQL server

[Angersma]

Is there documentation available on how to move our DB to another SQL server?    I don't see where we can update the SQL server name.   

[CharlesW · Accepted solution]

You can use the following steps to migrate the DB to a new server:

1. Make a backup of your App Portal database on your old database server.
2. After restoring the database backup on the new database server, ensure that the App Portal's service account is added as a DBO on the new database server.
3. On the App Portal Web Server, stop the ESD service.
4. In the App Portal Web Server's installation directory, make sure you change the name of the old database server to the new database server in all the following .config files:
   
   Note: Some of the web.config files have more than one reference to the database and all the references need to be updated

• <AppPortal Install Location>\App Portal\Web\web.config
• <AppPortal Install Location>\APM\Web.config
• <AppPortal Install Location>l\Service\ESDService.exe.config
• <AppPortal Install Location>\Utilities\MyApps\AppPortal.App.MyAppsExecutables.exe.config

5. On the App Portal Server, start the Windows Service called ESDService and perform an iisreset.
6. Launch the App Portal Website to check which database server App Portal is currently connected to. This can be verified under Admin | Settings | General tab.

[Angersma]

Thank you!