ER/One : A free Data Modeler Tool                 Download

ER/One Data Modeler allows developers to graphically design databases by using physical models and entity relationship diagrams to automatically generate the most popular SQL databases. It also allows developers to easier deploy the databases by offering a sophisticated visual data modeling environment. The software reduces errors in databases development while improves productivity and simplifies data modeling. Developers can visualize physical models structures to understand their databases, create new databases, modify, analyze, and optimize the solution. It is extremely easy to use and understand. Dedicated for both beginners and experts in database modeling, it is simple to get familiar with. ER/One provides all the features you expect of a professional database modeling and design tool.

ER/One Data modeler also allows:

  • Generation of physical data models.
  • Managing an unlimited numbers of tables.
  • Creation of index, keys, triggers, stored procedures, views, generators and domains.
  • Generation of a script for oracle, MS SQLserver, PostgreSQL, MySQL, Interbase and Firebird database engines.

Features

  • DBMS-specific data models
  • Large Model Management
  • Define entities, attributes, domains, indexes, sequences and relationships
  • Visual data modeling
  • Object browser (treeview)
  • Check Model
  • Generate DDL script
  • Options management
  • Triggers
  • Define views and procedures
  • Export model as an Image
  • Preview and print of model with printer setting
  • Duplicate an entity
  • Other interesting features remain to be integrated, after stabilizing the beta version:
    • Types of relationships: although these features exist in ER/One and are easily used (manually), many softwares do it automatically and so we plan to integrate them soon:
      • Identifying relationship
      • Many to many relationship
    • Undo-Redo
    • As well as several other features

Feedback

Your feedback interests us  , we kindly ask you to send us :

  • The detected bugs
  • Features to improve
  • Problems found in different databases (Example : Data types,used domains…)

For more

you can follow us on Facebook, Twitter and Google+

 

Changelog

0.8.4.1 | 26.10.2017

  • Fixed: A duplicate columns in keys fields and indexes fields  when there are multiple keys or multiple indexes

0.8.4 | 23.10.2017

  • Fixed: Incorrect order when there are a multiple columns primary key in one table (in script)
  • Fixed: Changing the name and the constraint name in the relationship generate an error
  • Fixed: some others issues
  • Add: many to many relationship
  • Add: check a duplicate constraint name if exist

0.8.3 | 09.10.2017

  • Fixed : Display problem in the preview
  • Fixed : Unable to add a column to an empty table
  • Fixed : Unsaved position of project frame in diagram
  • Fixed : Unsaved options choices of project
  • Add : Reach an entity from treeview  (right mouse  click)
  • Add : Reach a relationship from treeview  (right mouse click)

0.8.2 | 26.09.2017

  • Fixed : Error generated by deactivating primary key
  • Fixed : Page number of A4 in diagram
  • Add : Stored procedures
  • Add : Views