Summary
Migrating only App Portal Database to a New Server
Synopsis
This article lists the steps required to move the App Portal DB to a different database server.
Discussion
##WARNING##: ALWAYS BACKUP YOUR APP PORTAL DATABASE PRIOR TO ATTEMPTING THIS
General Steps to be followed:
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. In the App Portal Web Server, start the Windows Service called ESDService followed by an IIS reset.
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.
Related KB Articles
000007655
Additional Information
In case of App Portal 10.0.4: There are 2 Web.Config files in the Web and APM folders which need to be changed in addition to the ESDService.exe.config? file.
In case of App Portal 11.0.0 or later: There are 2 Web.Config files in the Web and APM folders which need to be changed in addition to the ESDService.exe.config?
and MyAppsExecutables.exe.config files.
