DDL Scripts from a Data Model
How to create DDL Scripts from Data Model?
- Open the physical data model “Data_Modeling_Relationship.txl”.
- Click menu Model/Verify Model.
- A new window will be opened.
- Check the appropriate objects like entities, functions, packages, materialized views, relationship, synonyms, data types etc which are listed in the new window.
- Click “Verify” button on the bottom of the page.
- It shows the errors and warning in a data model. If there are no errors and warnings.
- Click Menu/Generate DDL Script.
- A new window will be opened. It has tabs like what to generate, detail settings, referential integrity, Select List.
- Check the appropriate objects like directories, editions, entities, functions, java, materialized views, packages, permissions to objects, procedures, relationships, sequences, synonyms, user data types, user groups, views etc which are listed in the new window.
- In the bottom of the window, you can see buttons like Generate, Show Code, Show Log.
- Click the button ‘Generate’. It will save the DDL scripts in a file under a folder. You can see the location of the file in “what to generate tab”. Example: C:\Users\Data Modeling\Documents\Toad Data Modeler\GeneratedScripts\Generated.SQL
- If you have access to the databases, then you can directly execute those scripts and create database objects in database or database schema.
- Click Show. It will retrieve the information from that file “Generated.sql” and code is shown below.