From Chilli Source:
DDS-Lite is software for the modeling 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 Definition Language (DDL) Scripts for creating, dropping, and loading the database can be quickly and easily generated for all of the supported database servers. It supports all major databases, including Oracle, DB2, SQL Server, Informix, Sybase, MySQL, PostgreSQL, Interbase, Access, SQLBase, Ingres, ANSI, and MicroSQL. It features a project manager for managing the files that are used and generated by the application; full support for Windows shell; template language to define the Data Definition Language scripts to create the scripts exactly as you want them; and cross DBMS target compatibility. There's 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. Unlimited e-mail support is provided for all registered users of DDS-Lite with free upgrades to minor releases.