Database

Description

Cost

Production

The Production database is the agencies primary database for day to day use and is included at no additional cost.
​
This database should not be used for testing or exploring Bonterra, instead we recommend using one of the other available databases (e.g. Training, Migration, Mirrored etc). This will help ensure your Production environment is not negatively impacted.

Included/Required

Training Option A

The Training Option A database allows your agency to test new features and train Workers before your Production database is updated with a new version of Penelope (on the 2nd weekend of every month as per here).
​
Data in the Training Option A database will be a duplicate (de-identified) of your Production database (at the time of copy). This allows Workers to use real-life scenarios without accessing sensitive PHI information during testing and training. This database can be updated upon request, by submitting a support case, with your agency’s Production data.

Option of Training A or Training B.

Training Option B

The Training Option B database allows your agency to keep both databases (Production and Training Option B) on the same version of Penelope. This makes it easier when testing and training as the databases are always on the same version.
​
Data in the Training Option B database will be a duplicate (de-identified) of your Production database (at the time of copy). This allows Workers to use real-life scenarios without accessing sensitive PHI information during testing and training. This database can be updated upon request, by submitting a support case, with your agency’s Production data.

Option of Training B or Training A.

Migration

The Migration database provides your agency with a temporary database to test migration data before running any migration scripts on your agency's Production database.
​
Data in the Migration database will be a duplicate of your Production database (at the time of copy). Once your Production database has been copied, a script will be run to migrate the required data. It will then be verified to ensure the script has executed successfully and all data is as intended. This process may be repeated multiple times to ensure all data is correctly migrated and any issues have been resolved.

Optional

Mirrored

The Mirrored database provides your agency with a database for ongoing or one-off project needs. Bonterra Software's Tailored Services team can provide services for scripts should you require.
​
Data in the Mirrored database will be a duplicate of your Production database (at the time of copy).

Optional