Installation of DBA Tier No DBA Access
Home / Installation / Database Tier
Please read the Requirements first.
Check out the Installation of Always Encrypted Certificate. Please request the DBA user to complete this step if it is unavailable to you.
The standard instructions for installing the PxStat Data tier assume that the user has server level access to the database environment. However there may be certain cases where this does not apply, e.g
- The development team does not have sufficient access to the server
- We are in a Cloud environment using a serverless database, e.g. AWS R2
You will need to edit some of the files in order to conform with your own environment (e.g. setting paths, variables etc)
All files are found in the ..\db\ folder of the project
- CloudScriptInstallDba.sql
- CloudScriptInstall.sql
- datamodel.sql
- database.sql
Open the database.sql file. Either call the script with a value for $(DB_DATA), or else replace this with the new database name If you have the required DB access then run this script. Otherwise ask a DBA user to run it.
Open the CloudScriptInstall.sql file. Enter the values for DB_DATA (the database name) and CCN_USERNAME (the default user - this must be a valid system username) Change the path (Use Find...Replace) to ensure that the listed scripts have the same path as on your environment Ensure that the database.sql is the current up to date version Run the script
Open the CloudScriptInstallDba.sql file. This creates the jobs and schedules for system maintenance Enter the value for DB_DATA (the database name) If you have DBA access, run this file, otherwise give the file to someone who has this access
Cloud Environments If your database is a serverless database hosted by a cloud provider, there will be no possibility of creating the schedules as scripted in the CloudScriptInstallDba.sql file. You will need to create a solution based on the cloud provider and the solution. For example, if using AWS R2, you may need to solve this by running the schedules from a lambda function, or a scheduled job on a virtual server.
