Exporting a Database Schema

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 carried out 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 Database Schema into a DDL File

Prerequisites

You have a license for Innovator for Database Architects.
The appropriate engineering actions for the DDL import need to exist in the desired database systems in the model's imported profiles.
The user needs to have execution rights for the engineering action in their role.

Call a DDL export using the Extras>Export>DDL File submenu. The commands called start the respectively-configured engineering action. If you create a new model using the wizard, then an engineering action for the standard DDL imports is already predefined. You can add other engineering actions using the model configuration; the following tags need to be defined for this as a bare minimum:

NAME=DB.EXPORTDDL

The engineering action defines a DDL export and a corresponding command appears in the submenu.
Source=SQLServer

Defines the type of database system the DDL should be exported to.

Context

You want to export a database schema or database element in it (tables, views) from your Innovator database model into a DDL file so that you can import this into a relational database at a later stage.

How to proceed

Select the elements in the model that you want to export in the DDL file.
Select the desired engineering action for the DDL export from the submenu Extras>Export>DDL File.

The selected elements are exported as a DDL file.

The created DDL file and an XML log file are stored in the temporary user directory (e.g. ..\AppData\Local\Temp).

The content and information for generating the DDL are shown in the Info tool window. You can find the content of the DDL file in the DDL File tab; information about the DDL export can be found in the DDL Info tab.

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