Open Source Code Generators

Unify your data structures in XSD! XSD2DB Utility lets you manage database schemas using XSD files. Supports SQL Server and Jet databases. Can be extended to support other DB platforms. xsd2db requires .NET Framework 1.0

openDBcopy is a universal database utility to migrate data from and to any database given a JDBC driver. Standard plugins are included, custom ones can be added. Complete migration job saved as XML for easy re-use. Run with GUI or as batch.

SqlBuddy is a tool for use with Microsoft SQL Server and MSDE, written in csharp/ DotNet (.NET), to facilitate SQL script writing. It is serves a slightly different purpose that of Query Analyser, in that it is aimed to *help* the user write SQL.

The Object-Role Modeling (ORM) standard version 2, associated schemas and generation tools, and a reference implementation in the form of the Natural Object-Role Modeling Architect for Visual Studio (NORMA) product.

pgdiff is a utility which compares the table definitions of two databases, and returns the differences as PostgreSQL commands which will transform the structure of the first database to be identical to that of the second (c.f. diff and patch).

Propel is an object persistence (object relational mapping) tool for PHP5 based on Apache Torque. Propel generates PHP classes and SQL definition files for your data model and provides a runtime environment that transparently handles database operations.

Entity-relation (ERW) database modeling tool for both windows and *nix/*nux. PyDBDesigner intends to be similar to Power Designer or Erwin. Both physical and logical models are supported. Main features are database modeling, SQL generation, documentation

This site is intended as a location containing a suite of tools to (1) Aid in the design of db APIs to be utilized in a J2EE environment and (2) generate stubs for the db API, Java classes and SQL DDL necessary to support the MVC pattern and the Data Own

Model driven code generation can improve coding standards, speed, quality of development and reduce your costs. From my experience generating code from XML using XSLT is one of the best and fastest solutions. This is just the base of the framework presenting the idea, any code template can be implemented upon request. Some sample generators are present for SQL / PLSQL / C# / AnsiC / Java The main target is to generate DTO/BDO/POJO objects based on the database definitions in multiple languages aligning all technologies used by a development team. If you are willing to contribute drop a message.

Java developer's tool for query building that works with MySQL, AS400, Oracle, Sql Server and other JDBC DB's. Includes PreparedStatement Editor, Query Builder, SQL Code Generator, CSV Export, Database Navigator w/ regex filtering, Sql Diff & more.

Nextobjects is an Integrated Development Tool for Entreprise Applications. It use Turbine Torque for code generation. It is based on the Merise method.

A unique persistence layer for Java. CODO (Cursor Oriented Data Objects) maps generated Entity interfaces (suitable for DTOs) to a relational database via rendered SQL, reflection and JDBC Cursors where possible - avoiding associations.

The Combine Development Kit provides a Model View Controller (MVC) similar to Jakarta Struts, an Object Model code generator similar to Torque, and goes a step futher to auto generate configuration, actions and Smarty templates for the MVC.

DOnut's goal is to provide a framework for easing the incorporation of design patterns into the development process. DOnut is both a project and a tool for generating source code based on design patterns.

Data Class Generator is a tool that generates the needed classes to use with WPF (Windows Presentation Foundation) to enable easy two way bindings using the new binding concepts in XAML.

Hornet is a tool to browse and build MySQL databases, with the ability to connect to remote servers. It intends in the future to provide the capability to generate PHP-based interfaces to MySQL databases.

JSQL2iBatis, Generador de codigo. A partir de un fichero SQL con sentencias CREATE genera los ficheros java beans de iBatis y los xml correspondientes a los SQL Mapping. Es similar a Abator de iBatis pero mucho mas simple. Basado en plantillas Velocity.

JOR is a Java Object Relation mapping tool that is very simple to use. It works with all mayor databases and requires only minimal coding effort. JOR strictly follows the POJO / POJI (Plain Old Java Objects / Plain Old Java Interfaces) model.

MakeDBO is a MySQL library for PHP. It includes a mysql database interface and a DBO class builder to automatically generate PHP classes from your database tables. Currently requires Smarty templating engine.

MetaDog is preprocessor that generates code from a database's meta data. Templates contain JSP-like tags to markup source code. Since MetaDog is written in Java it is fully extendable and can be used to generate code for any language.

ORMGen is a scripting language planned to combine database definition and .NET object definition. It will also provide a plugin-style architecture to allow developers the opportunity to generate SQL code for a particular database system.

Olation is a O/R Mapping and Persistence Framework for C# and VB.Net. You can map object to an Sql based database or map object to xml file by using Olation. One of the design goal is try to minimize the config.

QueryDOM is a C# library that implements an extendable universal object model to parse and build SQL queries for every DB.

Converts XML files and/or SQL schemas into Java sources. Types of variables are determined from the sample values. Attributes and elements are treated the same, making writing the XML very simple. Directives are given in the java: and sql: namespaces.

Data Evolution for Java. Finch is a Data Transformation System based on JDBC and other Java blessed specifications. Finch is based on a component task architecture allowing users to create complex data manipulation jobs.