...
| Info |
|---|
The reference database is typically a schema-only copy of the production database (DDL and Stored Logic). In addition to DDL and Stored Logic, the reference database might also need to contain some data. This should be the minimum amount of data needed by the application team to package and deploy their DML scripts. This is typically limited to application configuration data and look-up tables (i.e., state, country, zipcodes, etc). |
...
Set Up Reference Database Credentials
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 Documentation on the specific credentials needed can be found in the following database-specific documents:
- Oracle Roles and Permissions for Datical DB
- Oracle on Amazon RDS Roles and Permissions
- SQL Server Roles and Permissions for Datical DB
- Azure SQL Database Roles and Permissions
- Postgres EDB and PostgreSQL Database Setup
- DB2 LUW Roles and Permissions for Datical DB
...
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.
...