...
Once the reference databases are setup, Datical will need database credentials to these new environments. In addition to the typical credentials needed to deploy database changes, Datical needs additional permissions so the packaging process can backup and restore the Reference Database as part of the build process. Documention on the specific credentials needed can be found in the following database specific documents:
- /wiki/spaces/DDOC59/pages/790954833
- /wiki/spaces/DDOC59/pages/795738600
- /wiki/spaces/DDOC59/pages/795836820
- /wiki/spaces/DDOC59/pages/791249167Oracle Roles and Permissions for Datical DB
- SQL Server Roles and Permissions for Datical DB
- Postgres EDB and PostgreSQL Database Setup
- DB2 LUW Roles and Permissions for Datical DB
Setup To Use the Reference Database the First Time
...
Before adding this database as the first step of your pipeline, you will need to create it and populate it as described in the Create the Reference Database section above. Once the database has been added to the pipeline, you will need to follow the process below to handle any sql scripts that have not yet been deployed into production.
...