ECMPS Support

The database backup and restore utilities that are new to the Beta B release were highlighted in a previous post. However, the FAQ on how to use the backup and restore to restored the Client Tool database to its original state needed to be updated. The new version of this FAQ is in the Client Tool section of the FAQs.

How can I restore my database to its original state without reinstalling the ECMPS Client Tool?

During Beta testing, it might become necessary to start over with a fresh database. In order to do that, complete the following steps:

1. Close the ECMPS Client Tool, if it is open.
2. Backup up your current database using the Database Backup Utility. The Database Backup Utility is accessed from the ECMPS Configuration Utility. The ECMPS Configuration Utility can be opened from the Windows Start menu. Select Start | All Programs | Perrin Quarles Associates | ECMPS Client | ECMPS Configuration Utility. (Or it can be accessed from \\PROGRAM FILES\PQA\ECMPS\ECMPS_CLIENT_CONFIG.EXE).
   In the ECMPS Configuration Utility, select Database Backup from the Maintenance menu.
3. Use the Browse button to select a folder to where the database will be backed up. Note, the backup files can be saved to any folder.
4. Click the Backup Databases button to backup the database.
5. Restore the database to its original state by using the Database Restore Utility. The Database Restore Utility is accessed from the ECMPS Configuration Utility. The ECMPS Configuration Utility can be opened from the Windows Start menu. Select Start | All Programs | Perrin Quarles Associates | ECMPS Client | ECMPS Configuration Utility. (Or it can be accessed from \\PROGRAM FILES\PQA\ECMPS\ECMPS_CLIENT_CONFIG.EXE). In the ECMPS Configuration Utility, select Database Restore from the Maintenance menu.
6. All three of the database backup files named FRESH in the folder \\PROGRAM FILES\PQA\ECMPS\DATABASESETUP\ need to be restored. Select these by using the Browse button. The default
   setting of C:\PROGRAM FILES\PQA\ECMPS\DATA for the data directory does not need to be changed.
7. Click the Restore Databases button to restore the databases.
8. Restoring the database to its original state will delete any data in the ECMPS Client Tool database. The next time you start the ECMPS Client Tool, you will need perform the steps involved in the initial login.

Please note, this will delete any data in your ECMPS Client Tool database. Before using the Restore Database Utility, use the Backup Utility to save any data that you do not want deleted.

Labels: Database, FAQ