Page Comparison

Table of Contents

...

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 (Improved performance in some environments)	Off by default. Datical provided an optional accelerator that compressed results before sending them from the database over the network and then decompressed them when they are received. The accelerator/compression driver was only available with versions 7.15 or lower. It has been deprecated with versions 7.16 and higher.
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 the storage clause information for XML changesets. The storage clause will be derived based upon the settings of the RefDB. Storage information includes table and index partition settings. You must include table and index storage information when packaging partitioned objects using the DDL or CONVERT package method.
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.

Note: To create a username, you must initially run:

CREATE USER "<datical_user>" WITH PASSWORD '<password>'

to create a user.

Info
Azure Postgres ONLY: Once the user is created, your complete connection username should be <username>@<server_name>. It is essential that @<server_name> is at the end of the username. Learn more here

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 or PSQL 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.
multiSubnetFailover	(only applies to SQLServer) Allows you to connect to the availability group listener of a SQL Server availability group or a SQL Server Failover Cluster Instance. Set to true to connect.
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 9

New Version Current

Key