Generating the Project-Schema-Specific SQL Scripts (with Wizard)
Procedure
- 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.
-
Click
Next.
You see the Generate JDBC deployment scripts wizard.
-
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 or sqlserver. The default value is oracle
Generate ANSI Scripts Select this checkbox 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. 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. -
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.
-
On the
Generate Migration SQL Scripts page, complete the values as follows.
Field Name Description Generate Migration Scripts Check this checkbox 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
Copyright © TIBCO Software Inc. All rights reserved.