5

Is there a free software that allows to edit database ER diagrams and export for different SQL database systems (e.g. MySQL, Oracle, SQLite, Microsoft SQL Server, etc.)?

  • 1
    @Fractaliste - the requirement to export ERDs to various systems is VERY precise (he even listed a minimum set). ERD also implies a GUI. And seriously... Android app for ERD? – DVK Feb 14 '14 at 19:40
  • 1
    Mh. I’ll ask our DBA about that, I think he had something like this. – mirabilos Feb 17 '14 at 12:34
  • 1
    @Fractaliste DVK said it all, I don't think you need more info... Do you only consider as quality posts those with huge amounts of text as oposed to simple straightforward questions? – Mikel Feb 17 '14 at 12:46
1

It won't export to everything you want, but I've had a lot of good experiences with Oracle SQL developer data modeller (Not to be confused with Oracle SQL developer). I currently don't have a copy running so no screenshots, but I found it significantly easier to use in designing a database ERD than visio, and forward engineering DDL from it. Once you've created the ERD for a database, you simply have to tell it to export the DDL (file -> export -> DDL) and it'll generate the commands for creating the database for you.

It runs on windows and linux, as long as java is installed. It will allow you to design an ERD and convert that to the necessary DDL for Oracle, DB2 or MSSQL. It dosen't support mysql or sqlite (Oracle has mysql workbench for mysql - but I have no direct experience with it)

1

SQL Power Architect logo

SQL Power Architect: Data Modeling & Data Profiling Tool will allow you create ER diagrams and then forward engineer that diagram into DDL for Oracle 9i/10g, PostgreSQL, Microsoft SQL Server 2000, Microsoft SQL Server 2005, MySQL, IBM DB2, or HSQLDB (but not SQLite).

It won't allow you to edit an ERD created in a different program, although you can import / reverse engineer a database schema and edit that imported diagram.

SQL Power Architect screenshot: opening screen

SQL Power Architect screenshot: entity-relationship diagram

SQL Power Architect screenshot: english comparison window

SQL Power Architect screenshot: forward engineering SQL

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.