Page Comparison

Table of Contents

...

In the Select a Database dialog. You provide the name of the step, an optional context, and choose the Database Platform (type).
Image Removed
Image Added
In the dialog Where is your (Name) Database Located?, you provide additional settings. Some settings vary by database type (Oracle settings shown).

...

Datical DB GUI	Description
Connection Settings
Hostname	Hostname or IP address for the database.
Port	50000 by default.
Database	Database name
REORG:	Automatically Perform with each Deploy Perform a DB2 reorg operation when changes are deployed to this step. The operation reclaims unused space.
z/OS:	Connection targets DB2 for z/OS Select if this is a DB2 system running on z/OS
Database Credentials
Username	Service name used by Datical to access the managed database for the step.
Password	Password for the service name. 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).
Optional Information
Contexts	Affects where changesets are deployed.
Labels	Defines labels to be applied to changesets deployed to this step.
Schema Name	Schema name to use. Requires Database property.
CLPPlus Timeout (seconds)	Time to wait for a CLPPlus script to complete. We recommend setting a value for this for all of your REF dbDefs, but only your REF dbDefs.
Storage Settings: Include Table and Index Storage Information	Include information about where and how the database is stored.
Project Creation Settings
Baseline	Create Baseline Changelog - select to create a baseline changelog from a snapshot of the schema. All objects currently in the database are captured and represented in the changelog.
StoredLogic	Externalize Stored Logic (Procedures, Package, Functions) - select to save stored logic objects outside of the changelog.

...

Datical DB GUI	Description
Connection Settings
Connection Type:	Choose one: BASIC - Basic (EZCONNECT) connection. Requires the following properties: Hostname Port Service Name or SID TNSNAMES/LDAP - TNSNAMES (local file) or LDAP (server). Requires the following properties: TNS Alias
Hostname	Hostname or IP address for the database.
Port	1521 by default
Identifier	Choose one and provide value: Service Name - Oracle Service Name, orcl is the default SID - Oracle Service Identifier
TNS Alias	Service Name. It must match the service name you want TNSNAMES - service name defined in a `tnsnames.ora` file LDAP - service name defined on an LDAP server. The LDAP server is one specified in an `ldap.ora` file
Accelerator: Enable Accelerator for Oracle (Improves Performance)	Off by default. Datical provides an optional accelerator that compresses results before sending them from the database over the network and then decompresses them when they are received.
Database Credentials
Username	Service name used by Datical to access the managed database for the step.
Password	Password for the service name. 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).
Optional Information
Contexts	Affects where changesets are deployed.
Labels	Defines labels to be applied to changesets deployed to this step.
Schema Name	Schema to use.
SQL*Plus Timeout (seconds)	Time to wait for a SQL*Plus script to complete. We recommend setting a value for this for all of your REF dbDefs, but only your REF dbDefs.
Storage Settings	Include Table and Index Storage Information Include information about where and how the database is stored.
Project Creation Settings
Baseline	Create Baseline Changelog - select to create a baseline changelog from a snapshot of the schema. All objects currently in the database are captured and represented in the changelog.
StoredLogic	Externalize Stored Logic (Procedures, Package, Functions) - select to save stored logic objects outside of the changelog.

...

Datical DB GUI	Description
Connection Settings
Hostname	Hostname or IP address for the database.
Port	5432 by default
Database	Database to access
Database Credentials
Username	Service name used by Datical to access the managed database for the step.
Password	Password for the service name. 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).
Optional Information
Contexts	Affects where changesets are deployed.
Labels	Defines labels to be applied to changesets deployed to this step.
Schema Name	Schema to use, requires Database property
EDB*Plus Timeout (seconds)	Time to wait for an EDB*Plus script to complete. We recommend setting a value for this for all of your REF dbDefs, but only your REF dbDefs.
Storage Settings	Include Table and Index Storage Information Include information about where and how the database is stored.
Project Creation Settings
Baseline	Create Baseline Changelog - select to create a baseline changelog from a snapshot of the schema. All objects currently in the database are captured and represented in the changelog.
StoredLogic	Externalize Stored Logic (Procedures, Package, Functions) - select to save stored logic objects outside of the changelog.

...

Datical DB GUI	Description
Connection Settings
Hostname	Hostname or IP address for the database.
Port	1433 by default
Application Name	Datical DB (application accessing the database)
Database Name	Database to access
Instance Name	SQL Server instance to use (database server). The default instance is used if an instance name is not specified.
Security	Integrated Security Use Windows authentication to access the database. When set for a DbDef, overrides the project setting to use runtime credentials.
Database Credentials
Username	Service name used by Datical to access the managed database for the step.
Password	Password for the service name. 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).
Optional Information
Contexts	Affects where changesets are deployed.
Labels	Defines labels to be applied to changesets deployed to this step.
Schema Name	Schema to use, requires Database property
SQLCMD Timeout (seconds)	Time to wait for a SQLCMD script to complete. We recommend setting a value for this for all of your REF dbDefs, but only your REF dbDefs.
Storage Settings	Include Table and Index Storage Information Include information about where and how the database is stored.
Project Creation Settings
Baseline	Create Baseline Changelog - select to create a baseline changelog from a snapshot of the schema. All objects currently in the database are captured and represented in the changelog.
StoredLogic	Externalize Stored Logic (Procedures, Package, Functions) - select to save stored logic objects outside of the changelog.

...

Versions Compared

Old Version 4

New Version 5

Key