Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Use the following tables as a road map to creating, managing, and configuring projects. 

...

PlanningEffectSee also
What are the phases in the release pipeline for applications?When you create the project, you create a step for each phase in the release pipeline. The step includes connection information and step settings.Identifying Databases for the Release Pipeline
What are the release pipeline contents?When you configure a project, you specify the database schema it manages. You choose from single-schema, multi-schema, and multi-database projects. Release Pipeline Contents: Database Schema
Create an audit database.

An audit database is used by projects to record operation activity. The audit database does not need to be the same type as the managed databases in the release pipeline. You need to do the following: 

  1. Provision a database for use by Datical DB as an audit database.
  2. Configure the first project to use the audit database. Upon first access, the Datical DB audit database schema is loaded into the audit database. 
  3. Configure other projects to use the audit database. 
For 2 and 3: 
Configuring a Project to Use the Audit Database
Determine how to manage database credentials. 

Typically you create a service user for Datical DB on each database in the release pipeline. You then configure project steps to use the credentials. 

By default credentials are stored with in the datical.project file. You can also set up dynamic runtime credentials, where operations prompt the user or read an environment variable any time they need to access the database.  

We strongly recommend to use runtime credentials because it is more secure than stored credentials (due to the possibility of the stored password being decoded).  


Database Credential Management

Project Creation and Initialization

...