|
Feature List
|
|
•
|
Enhanced Entity Relationship Diagram modeling allows
you to design a fully relational database, complete with Cascading Referential
Integrity Constraints, Indexes, Checks, Defaults, Triggers, Procedures and Unique
constraints.
|
|
•
|
Data Structure Diagram that is created automatically
from the Enhanced Entity Relationship Diagram shows the complete table structure.
|
|
•
|
Reverse Engineering of existing databases for Oracle,
SQL Server, DB2, Informix, Interbase, Access, Sybase, SQLBase, MySQL and PostgreSQL.
|
|
•
|
Data Definition Language (DDL) Scripts for creating,
dropping and loading the database can be quickly and easily generated for all
of the supported database servers.
|
|
•
|
Supports All Major Databases including Oracle,
DB2, SQL Server, Informix, Sybase, MySQL, PostgreSQL, Interbase, Access,
SQLBase, Ingres, ANSI and Pervasive SQL.
|
|
•
|
Multiple Models can be used to break large design
projects up into smaller sub-models. DDS-Pro manages the complete
design providing Single-Source Data Definition Language scripts,
Model Navigator and sub-model referential consistency.
|
|
•
|
Visual View Designer provides you with a View
modeling environment to visually create the most complex of Views in mere minutes.
With drag and drop functionality you can quickly and easily build the View SQL query
comprising of all manner of joins, search conditions, functions and even with an
unlimited numbers of subqueries.
|
|
•
|
Template Language to define the Data Definition
Language scripts allows you to create the scripts exactly as you want them.
|
|
•
|
Active Script to connect natively to the
supported DBMS Targets and issue DDL or DML SQL script commands and
queries.
|
|
•
|
Project Manager for managing the files that
are used and generated by the application. Full support for Windows
Shell such as delete to the recycle bin, drag and drop, file renaming
etc.
|
|
•
|
Integrate Tools from the Database vendors to
execute the Data Definition Language scripts directly within the application.
|
|
•
|
Cross DBMS Target Compatibility allows you to
design once and create for all. No need to concern yourself with vendor
specific variations to SQL syntax. All is handled by the application.
|
|
•
|
Java Source Code can be created directly from
the Enhanced Entity Relationship Diagram to contain the Data Definition
Language for any of the supported database targets. Source code can be
compiled and executed from within the DDS-Lite environment.
|
|
•
|
Visual Basic Source Code can also be created
directly from the Enhanced Entity Relationship Diagram.
|
|
•
|
SQL Editors with syntax high-lighting, context
sensitive auto-complete of SQL words. Build and Run environment integrated
with the DBMS venor tools.
|
|
•
|
ODBC Management within the Project Manager
allows you to have direct access to your most used ODBC connections.
These can be opened directly in
SQL Console.
|
|
•
|
Reports are created in grid views that can
be saved as Microsoft® Excel® or HTML format.
|
|
•
|
Flexible Datatype Mapping allows you to add
and remove Target DBMS datatypes, include datatype modifiers, and create
auto-increment datatypes.
|
|
•
|
User Defined Types or domains are now an
integral part of the Entity Relationship Diagram editing environment.
|
|
•
|
Datastore allows you to create sample data
for testing your model. The referential constraints are enforced to
ensure the data complies with the model. The data can be exported to
data files, insert directly into the database through an ODBC connection,
or formatted into SQL insert scripts.
|
|
•
|
Load Data Scripts allow you to load data
directly into the database.
|
|
•
|
Drag and Drop File Management is integrated
into the Project Manager and Editing windows.
|
|
•
|
Tutorial Exercises will enable you to straighten
the learning curve and have you productive within a few hours of using the
software.
|
|
•
|
Unlimited Email Support is provided for all
registered users of DDS-Pro. Coupled with free upgrades to minor release
versions, guarantees that you will always have the latest software and
full support backup whenever you need it. We want you to be a success.
|
