Using CA Application Test › Using the Workstation and Console with CA Application Test › Advanced Features › Generating DDLs

Generating DDLs

Setting the following properties in local.properties creates DDLs for reporting and VSE:

• eclipselink.ddl-generation=create-tables
• eclipselink.ddl-generation.output-mode=sql-script
• eclipselink.target-database=Oracle

To create DDLs for Agent, CAI, and CVS, use the following commands:

• java -jar LisaAgent.jar -ddl oracle (generate the Oracle DDL for CAI)
• java -jar LisaAgent.jar -ddl mysql (generate the MySQL DDL for CAI)