staruml-ddl - StarUML 2 Extension for DDL Generation

  •        42

This extension for StarUML ( support to generate DDL (Data Definition Language) from ERD. Install this extension from Extension Manager of StarUML. Belows are the rules to convert from ERD elements to DDL.



Related Projects

pgModeler - PostgreSQL Database Modeler

  •    C++

pgModeler - PostgreSQL Database Modeler - is an open source data modeling tool designed for PostgreSQL. No more DDL commands written by hand let pgModeler do the job for you! This software reunites the concepts of entity-relationship diagrams and the features that PostgreSQL implements as extensions of SQL standards.

ER diagram editor for eclipse

  •    Java

An Eclipse plugin for generating code out of an Entity-Relationship-Diagram (ERD). Currently SQL-DDL and POJO classes with EJB3.0 Annotations are supported. The diagrams conform to the diagram description by H. Buff (german book, ISBN 3-03-440201-5)


  •    Java

From the XML definition of your database, DewDrop will generate clean and human-readable SQL DDL code for any supported target database. This means you can define your database just once in XML, and have it work for any database automatically.

Database Synchronization Tool


This tool enables a development team to synchronize their local application databases instances to the central common application database instance using DDL and DML scripts.


  •    Perl

Oracle DBA's module for Oracle 8i, 8.0 and 7.3. Reverse engineers DDL for specified list of objects. Defrags entire tablespaces. Resizes tables/indexes to your standards. Creates user X with privileges of Y. Etc., etc., etc.

Convert Ms Word Table to Sql Table


This utility would help convert Ms word 2007 Tables to Sql tables. Add this macro to any word docx document and Run the macro. We get a text file containing all the tables which follow the naming convention converted into sql DDL statements. You just need to follow some naming

eyeLog - Database Audit Tool for Microsoft SQL Server


Most of the time, you focus on the implementation of the business requirements. There are a lot of follow up tasks that are not directly asked by the business. Monitoring the activity of a system is one of the tasks that is implictly asked. The goal of eyeLog is to monitor the a

Script SQL Database DDL

  •    CSharp

A tool which scripts out SQL Server 2000/2005 database objects to individual files in a manner which mimics Microsoft's Visual Studio for Database Professionals [aka, quot;Data Dudequot;]. These files can then be placed under proper source management control.


  •    Java

UpToDater allows teams to easily manage the migration of ddl changes from database to database. The framework is intended for Java based projects that rely on Ant.

Data Access Objects (DAO) for PHP

  •    PHP

Data Access Objects (DAO) code generator which reads schema directly from your database. PreparedStatement PHP class similar to JDBC. Database-neutral XML DDL Schema engine and SQL generator. Supports MySQL. Support for other databases coming.

TriActive Java Data Objects (TJDO)

  •    Java

TriActive JDO (TJDO) is an open source implementation of Sun's Java Data Objects (JDO) specification, designed to support transparent persistence using any JDBC-compliant database. It auto-generates DDL and auto-validates DB structure at runtime.



The main theme of this Jxt4DataBase is to bring a friendly environment to the user, those who are frequently executing DDL, DML Queries of a MySQL DataBase. Requirement: 1. MYSQL 5.0.45 2. JAVA 1.6.0-beta


  •    Java

JDDL is a Java implementation of the Data Definition Language for SQL. It provides an abstraction allowing DDL code to be portable across different databases. Additionally provides schema management and database utilities.

erd - Translates a plain text description of a relational database schema to a graphical entity-relationship diagram

  •    Haskell

This utility takes a plain text description of entities, their attributes and the relationships between entities and produces a visual diagram modeling the description. The visualization is produced by using Dot with GraphViz. There are limited options for specifying color and font information. Also, erd can output graphs in a variety of formats, including but not limited to: pdf, svg, eps, png, jpg, plain text and dot.The corresponding er file is in the examples directory.


  •    Java

ERMaster is Eclipse plug-in to make ER diagram. Functionally, Import from data base, Making of table definition book on Excel, Image output, DDL output, etc. are being offered.

Castor Doclet

  •    Java

Java doclet to generate both mapping and DDL files for Castor JDO


  •    Java

Automated DB Deployment and Maintenance (ADDAM) eases the tracking amp; applying of SQL (DDL, DML) scripts to manage changes. In effect, quot;Agile DB Developmentquot; for prod/dev. Other tools include reverse-engineer schema and import/export from/to CSV files.



T-SQL codegen script that creates audit trail triggers for SQL Server 2005 / 2008. Back-out procs, view to deleted rows, & rowhistroy function. Version 2 adds user context, SQL stmt, insert log, and base table DDL options. by SQL Server MVP Paul Nielsen. 4 yrs of bug fixes.

vcif - CIF Validation Software

  •    C

vcif is an open source software for validation of Crystallographic Information Files. It supports lexical, parser and dictionary validation (DDL 1 and 2 are fully supported, DDLm draft partially supported)