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 ?
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.
0
