AmaterasERD

AmaterasUML is an Eclipse plug-in to draw ER diagram. AmaterasERD has following features:

• ER diagram graphical editing
• Import from existing database
• Generate DDL from diagram
• Export table definition as HTML.

License

Eclipse Public License 1.0

Download

• net.java.amateras.db_1.0.7.jar
• net.java.amateras.db_1.0.6.jar
• net.java.amateras.db_1.0.5.jar
• net.java.amateras.db_1.0.4.1.jar
• net.java.amateras.db_1.0.4.jar
• net.java.amateras.db_1.0.3.jar

Put downloaded JAR file into ECLIPSE_HOME/plugins. AmaterasERD works with Eclipse 3.3. AmaterasERD also requires GEF and AmaterasUML.

How to Use

1. Choose [File]->[New]->[Others]->[AmaterasERD]->[ER Diagram]
2. Input filename and database type (1.0.0 supports only hsqldb) in the New Diagram Creation Wizard. You can also import from existing database in this wizard.
3. After the erd file is created, the diagram editor would be opened.
4. You can generate DDL by [Right Click]->[Generate]->[DDL].

History

 2010/01/03 - Version 1.0.7

• H2 Support
• Switching dialect after creating a diagram
• Improved foreign key creation behavior
• Improved HTML report
• Convert table / column name from context menu
• Show NOT NULL constraint in the diagram
• Show and snap to Grid, snap to other figure
• SQL Highlighting

See details here about new features.

 2009/05/05 - Version 1.0.6

• Note is available on the diagram
• Additional SQL (such as inserting initial data) of each table
• Auto diagram reloading when the file is updated such as SVN update

See details here about new features.

 2008/12/10 - Version 1.0.5

• Show selected tables DDL from the context menu
• Table background color has been configurable
• Incremental search in the JDBC importing wizard

See details here about new features.

 2008/9/3 - Version 1.0.4.1

• MySQL reverse engineering issue has been fixed.

 2008/8/21 - Version 1.0.4

• SQL comment generation in DDL
• CREATE TABLE with SCHEMA option
• Diagram Validation
• Linked Table
• Table copy and paste

See details here about new features.

 2008/6/7 - Version 1.0.3

• PostgreSQL and Oracle support
• Table re-importing improved
• Foreign keys decoration in the diagram
• Default column value support
• Outline view
• New DDL generate option to generate constraints as ALTER TABLE
• Index designing support
• Domain (Generic data type definition) support
• HTML report imprived

See details here about new features.

 2008/2/7 - Vresion 1.0.2

• New actions are available at the ER diagram context menu
  • Save as Image and Print
  • Export table definition as HTML
  • Auto layout
• Table definition dialog improved
  • Table / Column description
  • Auto increment column
• New extension point (net.java.amateras.db.generators)

See details here about new features.

 2007/7/19 - Version 1.0.1

• Apache Derby support
• Logical database design support

 2006/12/31 - Version 1.0.0

• Initial Release