Hi, I am a new user of Toad Data Modeler version 220.127.116.11
I work in a Oracle 12 environment.
The Data Modeler is simple and very intuitive to use. Nevertheless I had some requests for the interface (I will post a new message) and mainly for the scripting generation.
Problems when generating DDL Script:
There is no DROP TABLE clause, although I checked the “Drop tables with Cascade constraint clause” switch (see Menu - Model - Generate DDL Script - Edit default settings - Datail settings tab)
There is a sintax error when creating attributes. Toad creates a script using double quotes that are not required
CREATE TABLE ALL11_LOOKUP (“LOOKUP_TYPE” Varchar2(30 ) NOT NULL …
while the correct sintax is without quotes
CREATE TABLE ALL11_LOOKUP (LOOKUP_TYPE Varchar2(30 ) NOT NULL …
- There is a sintax error in CHECK Clause. The checked field is not specified
ENABLED_FLAG Varchar2(1 ) NOT NULL CONSTRAINT Flag_Enabled CHECK ( in(‘Y’, ‘N’)),
while the correct sintax is obtained repeting the field
ENABLED_FLAG Varchar2(1 ) NOT NULL CONSTRAINT Flag_Enabled CHECK ( Flag_Enabled in(‘Y’, ‘N’)),
- The costraint name acceptes the “minus” sign, while Oracle doesn’t accept that notation
ALTER TABLE ALL11_Chiavi ADD CONSTRAINT Lookup-Chiavi FOREIGN KEY …
i corrected the constraint names using underscores
ALTER TABLE ALL11_Chiavi ADD CONSTRAINT Lookup_Chiavi FOREIGN KEY …
It’s very important to me to understand if I can use Toad Data Modeler as a complete and fully functional software. Otherwise I have to look for other products (I tried without success Enterprise Architect)
Every comment/suggestion will be greatly appreciated.