Exporting a Database Schema into a DDL File

Export a database schema or individual database elements in it if you want to create or maintain database systems based on a database model

Exporting a Relational Database's Database Schema from a Database Model

Relational database systems are created and maintained when a database schema is exported out of the Innovator model.

Database schemata in the relational database and database model are compared using an integrated comparison function so that changes can be carried out easily and can be checked.

Unlike with other manufacturer-specific database design tools, conceptual schemata can also be mapped onto other manufacturer's database systems. Comparison is supported via JDBC or SQL/DDL.

If you integrate DB-ER mapping, you can use the complete reverse engineering, from the real database management system (DBMS) to the conceptual model.

Exporting a DDL File

Context

The dialog uses DDL configurations for all commonly used relational database systems.

You want to export a database schema or database element in it (tables, views) from your Innovator database model into a database-specific DDL file so that you can use this in a respective database at a later stage or align the content.

How to proceed

Select the database schema you want to export.
Select Import/Export>Export>(Nicht definierte Variable:UIVar_Menu.DdlFile).

The Export DDL File dialog appears.
Select the appropriate configuration for the database from the DDL Configuration drop-down list.

The default values or last settings of the user for the selected database type appear in the Options area.
Enter the path and name of the output file in the Output File input field or select the file using the Select... button.
To define the content and format of the DDL file, activate the corresponding check boxes.
Confirm settings with OK.

The selected database schema is exported as a DDL file with these definitions.

The generated DDL file and an XML log file are output to the specified directory.

A dialog informs you about the result of the export.

The dialog displays a link to the output file and information about the generation of the DDL file.

You can import the created DDL file into an existing relational database.