Generating the Project-Schema-Specific SQL Scripts (with Wizard)

Procedure

  1. In TIBCO BusinessEvents Studio Explorer, right-click the name of the project for which are creating SQL scripts and select Export > TIBCO BusinessEvents > JDBC Deployment.
  2. Click Next.
    You see the Generate JDBC deployment scripts wizard.
  3. Complete the values as follows:
    Field Name Description
    Database Type Select the type of database you are using from the drop-down list. Choose either oracle, mysql, sqlserver, or postgres.

    The default value is oracle

    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 schema 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 acme, the following scripts are generated: acme.sql, acme.aliases, acme_alter.sql, acme_cleanup.sql, acme_delete, and acme_remove.sql.
  4. Do one of the following:
    • If you are creating a new JDBC backing store, click Finish. The scripts are generated in the location you specified. Information about script generation is also printed to the Console tab.
    • If you are migrating an existing JDBC backing store, click Next. You see the Generate Migration SQL Scripts page.
  5. On the Generate Migration SQL Scripts page, complete the values as follows.
    Field Name Description
    Generate Migration Scripts Check this check box to generate SQL scripts to migrate an existing backing store. Once checked, the rest of the fields on this page are enabled.

    The default value is unchecked.

    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.
    Test Connection Click Test Connection to test if a success