Deployment SQL Scripts Wizard Fields
The following tables lists the settings present in the wizard for generating project-schema and migration scripts.
For details about the procedure, see Generating Deployment Scripts for a Store.
Project Schema Specific SQL Script Fields
Field | Description |
---|---|
Common Fields | |
Cluster Deployment Descriptor | Specify the name of the cluster configuration file. |
Output Directory | Specify the schema output file directory. |
Output File Name | Specify the schema output file name. |
Relational Database (JDBC) Backing Store Fields |
|
Database Type |
Select the type of relational database setup in your project. The values are:
The default value is |
Generate ANSI Scripts | Select this check box to use ANSI compatible SQL types during script generation.
Default setting is checked. |
Generate Optimized Scripts | Select this check box to eliminate script generation for in-memory events. |
Use Extended Max String Size | This is active only for the
oracle database type. Sets the maximum string size value to extended, that is to 32767 bytes.
|
Cluster Deployment Descriptor | Browse to and select the CDD file you want to use for the project. |
Output Directory | Browse to and select a directory where the scripts are to be generated, for example, BE_HOME/bin (This directory is used if you generate files manually.)
|
Output Script Name Prefix |
Enter a prefix for the output script filenames. For example, if you enter
|
Migration SQL Scripts Fields
Field | Description |
---|---|
Connection Configuration | Browse to and select the JDBC Connection shared resource used to connect to the existing backing store. |
Database URL | Enter the database URL that points to the existing backing store. |
Database Username | Enter the database username that was used when setting up the existing backing store. |
Database Password | Enter the database password that was used when setting up the existing backing store. |
Database Schema Owner | Enter the database schema owner for the existing backing store. |
Field | Description |
---|---|
ActiveSpaces Connection | Browse to and select the ActiveSpaces Connection shared resource used to connect to the existing backing store. All other fields in the page are automatically populated based on the ActiveSpaces Connection selected. |
Realm Server | Enter the URL of the TIBCO FTL Realm server. |
Grid name | Name of the property that is configured for the data grid name on the ActiveSpaces server. If not provided, the cluster name is taken as the Grid Name. |
Username | Enter the database username that was used when setting up the existing persistence store. |
Password | Enter the database password that was used when setting up the existing persistence store. |
Use SSL |
Select the check box to enable secure authentication. When you select the check box, the Trust All and Identity fields are enabled. |
Trust All |
Select the check box if the Trust Type in the store configuration is set to When you select the check box, the Identity field is disabled. |
Identity | If the Trust All check box is clear, provide path of the identity file. |
Field | Description |
---|---|
Database Node (Hostname) | Enter the hostname for the Cassandra server contact point. |
Database Port | Enter the port number for the Cassandra server contact point. |
Database Username | Enter the database username that was used when setting up the existing persistence store. |
Database Password | Enter the database password that was used when setting up the existing persistence store. |
Database KeySpace | Name of the keyspace to connect with on the Cassandra server. If not specified, the cluster name is used for the keyspace name. |
Use SSL |
Select the check box to enable secure authentication. When you select the check box, the following fields are enabled:
|
TrustStore Location | While using SSL authentication, provide the path to the base folder containing the certificate files. |
TrustStore Password | Password for the trust store while using SSL authentication. |
Requires Client Authentication | Select this check box if you enable two-way SSL authentication. When you select the check box, the ID File field is enabled: |
ID File | Path to identity file while using two-way SSL. |