aspose file tools*
The moose likes IDEs, Version Control and other tools and the fly likes Tool to generate the sql scripts from the ER Diagram ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » IDEs, Version Control and other tools
Bookmark "Tool to generate the sql scripts from the ER Diagram ?" Watch "Tool to generate the sql scripts from the ER Diagram ?" New topic
Author

Tool to generate the sql scripts from the ER Diagram ?

Malatesh Karabisti
Ranch Hand

Joined: Jul 28, 2010
Posts: 153

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

Joined: Mar 01, 2009
Posts: 1873
    
  16

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.

    No more Blub for me, thank you, Vicar.
    Vijitha Kumara
    Bartender

    Joined: Mar 24, 2008
    Posts: 3860

    Moved to IDEs, Version Control and other tools forum.


    SCJP 5 | SCWCD 5
    [How to ask questions] [Twitter]
     
    I agree. Here's the link: http://aspose.com/file-tools
     
    subject: Tool to generate the sql scripts from the ER Diagram ?