DATABASE DESIGN STUDIO - LITE (DDS-LITE) 2.20.6

DDS-Lite is for ERD modeling, SQL script generation and forward engineering of relational databases.

DDS-Lite is for ERD modeling, SQL script generation and forward engineering of relational databases. Enhanced Entity Relationship Diagram modeling allows you to design a fully relational database, complete with Cascading Referential Integrity Constraints, Indexes, Checks, Defaults and Unique constraints. Data Structure Diagram that is created automatically from the Enhanced Entity Relationship Diagram shows the complete table structure. 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. 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. 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. 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. Template Language to define the Data Definition Language scripts allows you to create the scripts exactly as you want them. SQL Editors with syntax hi-lighting, context sensitive auto-complete of SQL words. Build and Run environment integrated with the DBMS vendor tools. User Defined Types or domains are an integral part of the Entity Relationship Diagram editing environment.