Database Design Studio Professional Internet Download

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 MicroSQL.

Multiple Models can be used to break large design projects up into smaller sub-models, or schemas. 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.