An Implemented Database Model "data" that is stored in a Schema, Tables, 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 DataNamic.com. 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:
|