Generating DDL though logical model

Rajneesh S-Oracle

Hello All,

I am able to generate DDL from logical model as well. Logical model doesn't show indexes, constraints , data types, precession and length , FKs etc , however still generated DDL contains all these stuffs. Why so?

Thanks,

Rajneesh

Dave Schleis

Hello Rajneesh,

Just because you engineered a relational model to a logical model, and then were viewing at the logical model when you chose to export the DDL file, a relational model was still being used to generate the DDL.

Below is the view immediately after selecting Export DDL File.

Note that the relational model that is being used for the DDL export is listed in the DDL File Editor.

Dave Schleis

Hello Rajneesh,

Could you please explain how you are generating DDL from a logical model using SQL Developer Data Modeler?

I have been using this tool for years and I don't believe that I have ever seen this functionality.

What version are you using?

Thank you

--dave

Rajneesh S-Oracle

Hi Dave,

Yes , what you say that makes sense and that is my understanding also.

May be I am missing some thing with respect to steps (depicted below - version datamodeler-19.4.0.350.1424-x64):

Step1:

Step2:

Step 3:

Step4:

Step 5:

Step6: click OK

Thanks,

Rajneesh

Dave Schleis

Hello Rajneesh,

Just because you engineered a relational model to a logical model, and then were viewing at the logical model when you chose to export the DDL file, a relational model was still being used to generate the DDL.

Below is the view immediately after selecting Export DDL File.

Note that the relational model that is being used for the DDL export is listed in the DDL File Editor.

Rajneesh S-Oracle

Hi Dave,

Yes, got it. Thanks !!!

Regards,

Rajneesh