PGSQL Database:
1. Install a Applications Manager plugin instance with the same build number as the Standalone Applications Manager server, under the respective OpManager server.
2. Start the OpManager server once and stop it.
3. Take a backup of the database from the standalone server using the script as shown below:
Go to $AppManager_Home\bin directory in command prompt. (Run as Administrator)
Execute the backup script as follows:
In Windows:
- AppManager\bin > BackupPGSQLDB.bat --database
In Linux:
- AppManager/bin# sh BackupPGSQLDB.sh --database
The backup ZIP file will be generated under AppManager\working\backup folder.
4. Move the ZIP file to the OpManager\AppManager\working\backup folder of the new plugin installation.
5. Execute the restore script using above backup zip file as shown below:
In Windows:
- OpManager\AppManager\bin > RestorePGSQLDB.bat <Absolute path of backup ZIP file>
In Linux:
- OpManager/AppManager/bin# sh RestorePGSQLDB.sh <Absolute path of backup ZIP file>
6. Save the below queries in a text files called Queries.txt under OpManager/AppManager/working directory.
- delete from am_globalconfig where name='ADMIN_CONFIG_VERSION';
- delete from AM_UserPasswordTable;
- delete from AM_UserGroupTable;
7. Go to $OpManager_HOME/AppManager/bin directory in command prompt. (Run as Administrator)
In Windows:
- OpManager\AppManager\bin > BackupPGSQLDB.bat --queries
In Linux:
- OpManager/AppManager/bin# sh BackupPGSQLDB.sh --queries
8.. Once you execute the above steps, execute the config file backup and restore using the steps given in the CONFIG files backup and Restore section.
Microsoft SQL Database:
1. Install the plugin build with the same build number as the Standalone Applications Manager server. Both OpManager and AppManager Plugin should pointing to same Microsoft SQL server which is used in Standalone Applications Manager database server.
2. Once installed, navigate to OpManager\AppManager\conf\Plugin.properties file and update the database name to match the existing database in Standalone Applications Manager in the same MSSQL Server.
3. Connect to the database in SQL Server using SQL Management studio and execute the following queries:
- delete from am_globalconfig where name='ADMIN_CONFIG_VERSION';
- delete from AM_UserPasswordTable;
- delete from AM_UserGroupTable;
4. Once you implement the above steps, execute the config file backup and restore using steps given below.
5. Restart the OpManager Server once.
CONFIG files backup and Restore
1. Execute the backup config Script as follows:
In Windows:
- AppManager\bin > BackupConfig.bat
In Linux:
- AppManager/bin# sh BackupConfig.sh
2. The backup ZIP file will be generated under $AppManager\working\backup directory.
3. In the new installation, take the copy of the AMServer.properties file under $OpManager\AppManager\conf directory.
4. Move the ZIP file (from the standalone installation) to the $OpManager\AppManager\working\backup folder of the new standalone installation.
5. Execute the restore Script (in the new plugin installation) as given below:
In Windows:
- OpManager\AppManager\bin > RestoreConfig.bat <Absolute path of backup ZIP file under OpManager\AppManager\working\backup folder>
In Linux:
- OpManager/AppManager/bin# sh RestoreConfig.sh <Absolute path of backup ZIP file OpManager/AppManager/working/backup folder>
6. Once above script has been executed, paste the AMServer.properties file taken as backup copy in previous step.
7. Edit the AMServer.properties file and update value of am.appmanager.hostname, am.db.port, am.webserver.port if required.
NOTE: Backup configuration zip file name starts with the name "backupconfzip.