DDS-Lite is a versatile software that allows users to create detailed Entity Relationship Diagrams, Data Structure Diagrams, and Data Definition Language scripts. It supports all major databases and offers cross-DBMS compatibility. The software also includes project management tools and generates Java Source Code.
Using DDS-Lite, developers can quickly and easily generate Data Definition Language (DDL) Scripts for creating, dropping, and loading databases for all major databases, including Oracle, DB2, SQL Server, Informix, Sybase, MySQL, PostgreSQL, Interbase, Access, SQLBase, Ingres, ANSI, and MicroSQL. DDS-Lite also offers Cross DBMS Target Compatibility, enabling developers to design once and create for all. The software takes care of vendor-specific variations of SQL syntax, making the process much easier.
DDS-Lite comes with a Project Manager tool that helps users manage files used and generated by the application. There is also full support for Windows Shell, allowing users to experience features such as deleting files by sending them to the recycle bin, dragging and dropping files, and renaming files. Additionally, DDS-Lite allows users to integrate Tools from the database vendors to execute the Data Definition Language scripts directly within the application.
The software also offers the ability to create Java Source Code, directly from Enhanced Entity Relationship Diagram, containing the Data Definition Language for any of the supported database targets. Developers manage source code compilation and execution from within the DDS-Lite environment. The Template Language, offered within DDS-Lite, allows developers to define the Data Definition Language scripts precisely as they require.
DDS-Lite provides SQL Editors with syntax highlighting and context-sensitive auto-complete of SQL words. Its Build and Run environment are integrated with the DBMS vendor tools. The software enables User-Defined Types or domains as an integral part of the Entity Relationship Diagram editing environment. Overall, DDS-Lite offers comprehensive features for designing, managing, and implementing relational databases across most of the major database platforms.
Version 2.20.6: New Features