Note: The following article is intended to be used by an IT staff member or user with administrator privileges. Before beginning this process, please ensure you contact Pronamics Technical Support on +61 7 3481 9626.
The Expert Estimation Server can be configured to store its required database files in an alternative location. All data relating to projects, attachments and security permissions, by default, can be found in C:\ProgramData\Pronamics\Expert Estimation\Database.
The following process provides the ability to relocate an Expert Estimation Server database to an alternative directory. This process assumes an Expert Estimation Server component has already been installed. The custom database directory configuration will need to be redefined if an upgrade to the server component is run.
Note: Ensure there are no users currently accessing the Expert Estimation Server as it will need to be stopped.
Custom Database Location Setup
- Open the Local Services window of the machine that has the Server component of Expert Estimation installed. To open the Local Services window, open the Run command (Windows key + R) and type services.msc, then click OK.
- In the Services list find the services listed as “Expert Estimation Server”, right-click and select Stop.
- Navigate to C:\ProgramData\Pronamics\Expert Estimation
- Rename the folder ‘Databases’ to ‘OLD_Databases’
- Copy all files and folders within the ‘OLD_Databases’ directory
- Navigate to the custom directory in which the database is to be stored, and paste the copied database files
- Locate the directory in which the Expert Estimation Server is running. This can be identified from the Properties of the service within the Windows Services. The default installation location is:
C:\ProgramData\Pronamics\Expert Estimation\Server\Server.<version> - Locate Pronamics.ExpertEstimation.Server.exe.config file and open in a text editor, such as Notepad, ensuring it is Run As Administrator
- Find the <appSettings> section and press the Enter key at the end of the line to add a new line below it
- Type the following on the newly created blank line. The placeholder ‘DatabaseLocation’ should be replaced with the custom folder location to which the database files are saved:
<add key=”CustomisedBaseFolderPath” value=”DatabaseLocation” /> - Save and close the file
- Open Windows Services and locate the service Expert Estimation Server
- Right-Click on the service click Start.
Once complete, the server component will communicate with the database files stored in the new custom directory.