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/3.3/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 oracle10g oracle11g db2
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.