Database Distribution
- Last UpdatedFeb 13, 2023
- 2 minute read
To display the Database Distribution window, select Data > Database Distribution on the main ADMIN menu bar. This shows all the project databases and how they are distributed across the locations.
A column is shown for each location (titled by its 3 character location id). Database status is indicated at each location as follows:
|
+ |
indicates the database is primary at this location |
|
- |
indicates the database is allocated to this location but is primary elsewhere |
|
> |
indicates the database is in transit from this location under a pending transaction |
|
* |
indicates the database is foreign and allocated to this location |
Use the Refresh option to update the list following any change such as the deletion of a database or a change of primary location.
Use the Clear Selection option to clear any row selection in the Database list.
In order to change the primary location of one or more databases, select the required databases in the upper list, and select the location where they are to be primary in the lower list, then click Change Primary Location. The databases will be allocated if necessary to the selected location and changed to be primary at that location.
Note:
If there are ANY users in the Multiple Database (MDB) any changes to the primary location
of the systems database whatever MDB is been used is blocked. This is particularly
relevant to an Admin user with the MDB set, a FREE user in ADMIN also blocks any changes to the primary
location.