WAS v8.5 > Administer applications and their environment > Deploy enterprise applications

Export DDL files

We can export data definition language (DDL) files in the EJB modules of an application. Exporting DDL (Table.ddl) files in the EJB modules of an application downloads the DDL files to a location of your choice.

1. Click Applications > Application Types > WebSphere enterprise applications in the dmgr console navigation tree to access the Enterprise applications page.
2. 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.

3. 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

WAS v8.5 downloads the DDL file to the specified location.

Related

Recreating database tables from the exported table data definition language

Reference:

Enterprise application page

+

Search Tips   |   Advanced Search