Feature

Details

DDS-Lite

DDS-Pro

Enhanced Entity Relationship Diagram

Built upon the Chen model for entity relationship diagrams, but extended to support generalizations and specializations of entities. Note that this is a proper Entity Relationship Diagram, not a Data Structure Diagram as other software falsely calls an ERD.

Data Structure Diagram

In accordance with proper ERD modeling, the Data Structure Diagram is a representation of the physcial data structure. This view includes all foreign keys and foreign key references.

Project Manager

Manages all of the files related to the design project, as well as ODBC connections. Supports drag and drop, recycle bin deletions and shell file renaming. Integrates support for all DBMS tools.

Forward Engineering

Create Data Definition Language scripts to Create, Drop and Load the database.

Reverse Engineering

Creates ERD models directly from a database. Extracts tables, views, procedures, triggers, indexes, unique and check constraints, user information and roles.

Tables

Data Definition Language to create tables with cascading foreign key constraints, indexes, checks etc.

Views

Data Definition Language to create views.

View Designer

Drag and Drop view designer makes creating views as easy as moving the mouse.

Procedures

Wizards to help you create procedures for all of the DBMS Targets that support procedures and/or functions.

Triggers

Wizards to help you create Triggers for tables and views.

Integrated Toolsets

Build and Run environment that allows you to add any DBMS tool to the system toolsets. Scripts can be run directly from within the application.

SQL Editors

SQL editors that are integrated into the design environment makes edit SQL a breeze.

Datastore

Off-line data to test and populate the database.

Java Source Code

Generate Java source code to support any of the DBMS Targets. The application provides and complete, create, buil and run environment for Java development. (Requires JDK to be installed on the system.)

Visual Basic Source Code

Generate VB code at the click of a button. (Requires Microsoft Visual Basic to compile the code.)

Active Script

Connect natively to a database and issue DDL or DML SQL statements to the database server.

Reports

Grid reports which cna be saved as HTML or Microsoft Excel format.

Multiple ERD Models

Provides support for splitting large projects up into multiple models while providing single source Data Definition Language script support.

Integration to SQLConsole

Run SQLConsole directly from the application.

User Defined Types

Add your own column data types to the model for easy maintance of commonly used types.

Datatype Mapping

Maps the generic application datatypes to DBMS sepcific datatypes.

Datatype Modifiers

Add DBMS independent datatype modifiers to the model.

Data Definition Language Templates

Fully configurable DDL Templates makes it easy to get the script content just the way you want it.

Load Data Scripts

Create load scripts for many of the DBMS Targets.

DBMS Independent Design

Design the database independently of any specific database. Once the design is done, let the application take care of conversion to the Targets.

Support For All Major Databases

Supports Access, ANSI, DB2, Informix, Ingres, Interbase, MicroSQL, MySQL, Oracle, PostgreSQL, SQL Server, SQLBase and Sybase.

Syntax High-lighting

Configurable syntax high-lighting of keywords in all text editors.

Auto-complete SQL Keywords

Auto complete SQL keywords in the SQL editors.

Mouse Wheel Support

Mouse wheel support for scrolling, panning and zooming in the ERD and DSD editors. Scrolling in all other views.

Getting Started Tutorials

Straightens the learning curve, getting you on track in the shortest possible time.

Free Minor Version Upgrades

All upgrades within the same Major version are totally free.

Free Email Support

Prompt, knowledgable response to all of your questions and feedback.