This week's book giveaway is in the Cloud forum.
We're giving away four copies of Terraform in Action and have Scott Winkler on-line!
See this thread for details.
Win a copy of Terraform in Action this week in the Cloud 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Rob Spoor
  • Bear Bibeault
Saloon Keepers:
  • Jesse Silverman
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Al Hobbs
  • salvin francis

Tool to generate the sql scripts from the ER Diagram ?

 
Ranch Hand
Posts: 153
Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 4109
    72
    Hibernate Fedora Chrome
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    Moved to IDEs, Version Control and other tools forum.
     
    reply
      Bookmark Topic Watch Topic
    • New Topic