Exporting DDL files
You can export data definition language (DDL) files in the enterprise bean (EJB) modules of an application.
Overview
Exporting DDL (Table.ddl) files in the EJB modules of an application downloads the DDL files to a location of your choice.
Procedure
- Click Applications > Enterprise Applications in the administrative console navigation tree to access the Enterprise Applications page.
- Place a check mark in the check box beside the application and click Export DDL. If the application has no DDL files in any of its EJB modules, then the message No DDL files were found is displayed at the top of the page. If the application has DDL files in its EJB modules, then a page listing DDL files in the format application_name.ear/_module.jar_Table.ddl is displayed.
- Click on a file in the list and specify the location to which to download the file.
For Firefox browsers, right-click the file name, select Save Link As, and specify the location to which to download the file.
Mozilla browsers might display the contents of the Table.ddl file instead of saving the file to disk. To save the file, edit the Helper Application preference settings of the Mozilla browser by adding a new type for DDL and specifying to save DDL files to disk. That is, set MIME type = ddl and Extension = ddl.
Results
The DDL file is downloaded to the specified location.
Related tasks
Recreating database tables from the exported table data definition language
Deploying and administering J2EE applications