This is Matthew Phan, systems consultant for Dell Software. In this short video, I'll generate DDL scripts and reports for the sample video rental model included with Toad Data Modeler.
Now, I can take this model and generate a DDL script by going to Model, Generate DDL Script. This window will allow me to customize my script as needed, but I'll go ahead with the default settings. I'll select Show Preview and click on Generate. Just like that, I have a script that I can run in Oracle to deploy this model to a live database.
I can also quickly create a report for this model by going to Model, Generate Report, Report Wizard. The Wizard will allow me to customize my report, first by the type of file, type of report, layouts and colors, what to report on, and so on. When I'm ready, I'll click Execute. Then I'll click the Show button.
The result is a very clean HTML report that you can host on your own intranet and share with your teammates. Included in the report is a copy of the ER Diagram, where you can click on any individual component to get more details.