DDLGeneratorTask

DDLGeneratorTask specifies an action, data and property files, the objects on which the action is performed, and various behavioral attributes. 

<DDLGeneratorTask
			action="action"
			targetDirectory="path to the samples directory"
			targetFilePrefix="targetFilePrefix"
			modelProfiles="modelProfiles"
			dbType="dbtype" 
			dialect="dialect" 
			username="username"
			password="password"
			dbUrl="dbUrl"/>
Attribute Type Req? Description
action String Yes The action to be performed by the generated scripts.
  • create - scripts to create tables and related database objects are created.
  • drop - scripts to delete tables and related database objects.

The action is case insensitive.

targetDirectory String No The location of the directory where the generated scripts files are stored.

Default: TIBCO_HOME/administrator/<version>/samples/ddl.

targetFile String No The name of generated script file. the location of the script file. If specified, this attribute takes precedence over the targetDirectory attribute.
targetFilePrefix String No The prefix for the generated scripts. Used only when the targetFilePrefix attribute is used.
dbtype String No The database for which to generate the scripts. Valid values:
  • sqlserver
  • db2
  • oracle
dialect String Yes The dialect of the specified database.
username String No Used to connect to the database.
password String No Used to connect to the database.

The password for the specified username attribute can be either clear text or encrypted value.

dburl String Yes Used to connect to the database.
modelProfiles String Yes Used to specify a model for which to generate the scripts. Multiple values can be specified using a comma-separated list.
Valid values:
  • admin
  • governance
  • commonlogging
  • security
  • all - generate scripts for all the models listed above.