Setting A Custom Database Location

The Expert Estimation Server can be configured to store its required database files in an alternative location. For more information about where Expert Estimation stores its database files by default, please refer to the ‘Server Database Storage’ section.

The following process will relocate an Expert Estimation Server database to an alternative directory. This process assumes an Expert Estimation Server has already been installed and an Administrative knowledge of Windows Operating Systems is understood.

Ensure there are no users currently accessing the Expert Estimation Server as it will need to be stopped. This process requires Administrative Privileges to be completed successfully.

  1. Open Windows Services and locate the server Expert Estimation Server.
  2. Right-click on the service and click Stop. This will ensure the Expert Estimation Server process is not running when relocating the database.
  3. Locate the directory in which the Expert Estimation Server executable is stored. This can be identified from the Properties of the service within the Windows Services. 

Note: The default installation location is: C:\ProgramData\Pronamics\Expert Estimation\Server\Server.<version>

  1. Locate Pronamics.ExpertEstimation.Server.exe.config file in the folder and open in a text editor, such as Notepad++, ensuring it is Run As Administrator.
  2. Find <appSettings> and press the Enter key at the end of the line to add a new line below it.
  3. Type the following on the newly created blank line:

    <add key="CustomisedBaseFolderPath" value="DatabaseLocation" />.
  4. The placeholder "DatabaseLocation" should be replaced with the custom folder location, for example:

    C:\NewDatabaseLocation\Server.version
  5. Save and close the file.
  6. Open Windows Services and locate the server Expert Estimation Server.
  7. Right-click on the service and click Start.
  8. Navigate to the custom database location set in Step 8 and confirm the new database has been created.
  9. Open Windows Services and locate the server Expert Estimation Server.
  10. Right-click on the service and click Stop.
  11. Navigate to C:\ProgramData\Pronamics\Expert Estimation
  12. Rename the parent folder "Databases" to "OLD_Databases" and copy all files and folders within the "OLD_Databases" directory.
  13. Navigate to the custom directory in which the database has now been created and paste the copied files.
  14. Open Windows Services and locate the server Expert Estimation Server.
  15. Right-click on the service and click Start.