• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Tool to generate the sql scripts from the ER Diagram ?

 
Malatesh Karabisti
Ranch Hand
Posts: 153
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I am trying to generate the SQL scripts from the ER Diagram. I did some search on oracle sql developer modeler. from this we can import the existing schema and generate ER diagram. I want the opposite way ER diagram to SQL Script

Please suggest me on, are there any tools available to generate the SQL scripts from the ER Diagram ?

Thank You.
 
chris webster
Bartender
Posts: 2407
33
Linux Oracle Postgres Database Python Scala
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Oracle SQL Developer/Data Modeler does this for you from your relational model e.g. from the model you created when you imported the schema.

I have SQL Developer 3.1.07, and in this version you need to open your relational model, then go to File --> Data Modeler --> Export --> DDL File.

If you don't have a relational mode, but only a logical model, then you first need to forward engineer the logical model to a relational (physical) one:

  • Create a new empty relational model and give it a sensible name.
  • Then right-click on your logical model in the model-browser, select "Engineer to Relational Model" and follow the wizard.


  • After that, you should be able to generate your DDL from the rel. model.
     
    Vijitha Kumara
    Bartender
    Posts: 3913
    9
    Chrome Fedora Hibernate
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Moved to IDEs, Version Control and other tools forum.
     
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic