Generate SQL DDL (Exporting)

An Operational Database Model “data” that is stored in a DBMS Schema, DBMS Tables, DBMS Columns, and Keys can be used to generate a SQL DDL export file. This file can then be imported into an SQL-engine based DBMS or possibly to a database diagrammer. The one employed by Whitemarsh is Dezign by It is inexpensive and very capable. There are two buttons at the right side of the screen, View Generation Result and Data Model Diagrammer. Properly linked by embedding a Windows Short Cut, the diagrammer will begin to execute. It can then read the Generated SQL DDL file and a diagram can be shown.  The process to accomplish the generation of the SQL DDL includes:

  • Start the Operational Data Model Metabase System Module
  • Select the DBMS
  • Enter User Name and Password
  • Select the Menu Item, DBMS Schema and DBMS Tables, then the subordinate item, SQL DDL, and finally the Generate process
    • Highlight the appropriate DBMS Schema
    • If an Operational Database Database Model tree hierarchy is to be dynamically created, select the DBMS Table around which the data model hierarchy is to be created.
      • Press the Display Operational Database Model Diagram
    • If a SQL DDL output file is to be created,
      • Select the output file
      • Clear the output file
      • Select how Super & Subtype entities are to be processed
      • Press either the Generate DBMS Schema based data model button, or the Generate root-table based data model
  • Press either the View Generation Result or
  • Press the Data Model Diagrammer button

For Sales and Corporate: 1-301-249-1142

Whitemarsh Information Systems Corporation

2008 Althea Lane Bowie, Maryland 20716 USA

Copyright 1981 - 2016, Whitemarsh Information Systems Corporation
Proprietary Data, All rights Reserved