• 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: 3953
    21
    Chrome Fedora Hibernate
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Moved to IDEs, Version Control and other tools forum.
     
    And then we all jump out and yell "surprise! we got you this tiny ad!"
    the new thread boost feature brings a LOT of attention to your favorite threads
    https://coderanch.com/t/674455/Thread-Boost-feature
    • Post Reply Bookmark Topic Watch Topic
    • New Topic
    Boost this thread!