After running the Model Update wizard, new relationships (Foreign Keys) are missing from the workspace.
The following steps will reproduce the issue:
1. Run Reverse Engineering (RE) wizard and RE a model from an Oracle 9i database
2. Update the structure of the database, eg. add a new relationship
3. Run the Model Update wizard
Note that the new entities (table) come across fine, but the new relationships (foreign keys) are missing.
This is a bug. During model update, shortcuts of objects should be automatically created in those workspaces where option Auto Complete is selected.
WORKAROUND:
Please have a look at Model Explorer, the relationship has been loaded and should be there. Right-click the entity on workspace and select Fill Parent and Child Objects. Shortcut of relationships of the entity will be added to the workspace.
STATUS:
Waiting for a fix in a future release of Toad Data Modeler
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center