Win a copy of Svelte and Sapper in Action this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

Tool to generate the sql scripts from the ER Diagram ?

 
Ranch Hand
Posts: 153
Oracle Java
  • 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.
 
Bartender
Posts: 2407
36
Scala Python Oracle Postgres Database Linux
  • 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.
     
    Bartender
    Posts: 4107
    72
    Hibernate Fedora Chrome
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Moved to IDEs, Version Control and other tools forum.
     
    Or we might never have existed at all. Freaky. So we should cherish everything. Even this tiny ad:
    Thread Boost feature
    https://coderanch.com/t/674455/Thread-Boost-feature
      Bookmark Topic Watch Topic
    • New Topic