Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Configuration : DDL Script Generator

DDL Script Generator
The DDL Script Generator is used to generate database specific DDL scripts that are based on user commands and configuration.
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"/>
The action is case insensitive.
Default: TIBCO_HOME/administrator/3.2/samples/ddl.
The password for the specified username attribute can be either clear text or encrypted value.
Invoking the DDL Script Generator
You can explicitly generate DDL scripts and use them to execute on the database.
 
1.
2.
Navigate to the TIBCO_HOME/administrator3.2/samples/ddl folder.
3.
Edit the generate_ddl.xml file and update the DDLGeneratorTask element. See DDLGeneratorTask for more information.
4.
Execute ant -f generate_ddl.xml
Result 
The DDL scripts are generated and can be used to execute on the database.
Example 
Sample DDLGeneratorTask element
<DDLGeneratorTask
action="create"
targetDirectory="${admin.ddl.samples.directory}"
targetFilePrefix="create"
modelProfiles="all"
dbType="sqlserver2008"
dialect="com.tibco.amf.sharedresource.runtime.core.hibernate.dialects.SQLServerDialect"
username="username"
password="password"
dbUrl="jdbc:sqlserver://host name:port;DatabaseName=db name"/>

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved