You can generate a DDL file (Data Definition Language) for any relational databases using a database model's database schema. Generation instructions are integrated by means of DDL configurations for the standard database systems.
Purpose
As the database language, DDL (Data Definition Language) is the data description language of a database.
You can generate a DDL file for any relational databases using a database model's database schema. Generation instructions are integrated by means of DDL configurations for the standard database systems.
The dialog allows the selection of the DDL configuration for a certain database type and the definition of the output file, DDL content and format.
The definitions are saved in a user-specific manner for each DDL configuration and are available again when the next call takes place. Each DDL configuration can be reset to the default values.
Sequence Control Files
The $INODIR\java\InoIMInOut\configuration directory contains the control files for the DDL export.
- datatypes.xml for implementing JDBC data types in Innovator data types upon comparison with the model and difference DDL export in the DB Manager
- positions.xml for positioning type system options upon DDL export
- standardOptions.xml for automated generation of type system options upon DDL export
- stereotypeoptions.xml for changing type system options in the model into DB options upon export
- viewwhere.xml with all strings which "WHERE" will not be inserted at the beginning of a View expression
Prerequisites
You have a license for Innovator for Information Architects.
You have loaded the DB-specific profile and logged-in with the Information Architect role.
The DB schema or DB element to be exported is selected.
Call
Select Import/Export>Export>DDL.
Structure
The DDL Configurations drop-down list is shown to the left. It lists the DDL configurations delivered as XML files. You can use the Reset to default values button below the drop-down list to reset each DDL configuration to the settings in the configuration files.
The Options area can be seen on the right and shows the selected DDL configuration. Tool tips contain information about the respective option.
Below are the following:
- Output File field for entering the path and file name of the DDL file or for its definition using the Select... button
- Drop-down lists for formatting characters and character sets (UTF-8 as default or ISO-8859.1)
- Check boxes of configured DDL content in accordance with the DDL configuration
The OK standard button starts the export.
The Cancel standard button closes the dialog.
Related Topics
