Chat now with support
Chat with Support

Toad Data Modeler 7.0 - User Guide

Introduction User Interface Models and Model Objects
Physical Data Model
Entity Relationship Diagram Objects Basic Database Design Advanced Database Design
Universal Data Model Logical Data Model Working with Model Objects
Features and Tools
Application Variables Export/Import DDL Script Generation Graphics Model Actions Print Create New Project Reports Reverse Engineering Scripting and Customization About Templates Tips and Tricks Toad for Oracle Integration Toad Intelligence Central (TIC) Integration Tools Version Control
Options and Configuration Databases
Amazon Redshift 1.0 IBM DB2 LUW 9.5 IBM DB2 LUW 9.7 IBM DB2 LUW 10.1 IBM DB2 LUW 10.5 IBM DB2 LUW 11.1 IBM DB2 z/OS 10 IBM DB2 z/OS 11 Greenplum 4.1 Greenplum 4.2 Ingres 9.3 Ingres 10.0 EDB Postgres Advanced Server 10 Microsoft Access 2007/2010 Microsoft Azure SQL Database V12 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 Microsoft SQL Server 2017 MySQL 5.0 MySQL 5.1 MySQL 5.5 MySQL 5.6 MySQL 5.7 MySQL 8.0 Oracle 10g Oracle 11g Release 1 Oracle 11g Release 2 Oracle 12c Release 1 Oracle 12c Release 2 Oracle 18c Specifics - Oracle 12c Release 2 PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 PostgreSQL 10 SQLite 3.7 Sybase ASE 15.5 Sybase ASE 15.7 SAP ASE 16.0 Sybase IQ 15.2 Sybase SQL Anywhere 11 SAP SQL Anywhere 17 Teradata 13 Vertica Database 8.0
Copyright Legal Notices

Copy Objects

In Toad Data Modeler you can copy objects between models of the same or different database platforms and versions.

Note: Even though it is possible to copy and paste objects to a different model of different database platform or version, it is encouraged to use Model Convert function, even for single objects. The copy-pasting method is faster, but more error-prone, while the Model Convert method is slower, but more robust.

TIP: Instead of copying one object multiple times, it is better to add it to a Gallery. See Gallery for more information.

To copy objects on Workspace

  • Drag an object on Workspace, hold CTRL and drop the object copy somewhere else on Workspace.
  • Select Edit Menu | Copy/Paste
  • Use CTRL+C and CTRL+V shortucts

To copy objects between Workspaces/Models

  • Select Edit Menu | Copy in source model, Paste in target model
  • Use CTRL+C and CTRL+V shortucts

To copy objects in Model Explorer

  • Drag an object in Model Explorer, hold CTRL and drop the object copy on the object type folder (e.g. Entities).

To copy objects in object type dialogs (Model Menu |Model Items | Entities, Views etc.)

  • Drag an object in the dialog, hold CTRL and drop the object.
  • Use CTRL+C and CTRL+V shortucts

Combinations of these copy methods are possible - e.g. copy from Model Explorer to Workspace.

TIP:

  • To copy more objects at once, make multiple selection and use one of the copy techniques.
  • Making a Copy of Multiple Objects in Workspace (CTRL+A, CTRL+C, CTRL+V): Before you press CTRL+V to paste the objects, close the Model Explorer dialog to accomplish the operation much faster. (The larger your model is, the more significant difference in speed you will notice.)

Move Objects

To move objects on Workspace, you can use: 

  • Drag&Drop technique
  • Keyboard arrows

TIP: To set the size of a step for moving shapes on Workspace, select Settings | Options | Application | Graphics | Move Objects by (mm/10) (in tenths of millimeter).

To move objects between Model Explorers

Use Drag&Drop technique. You need to drop the object onto its root folder in the target Model Explorer.

To move objects in object type dialogs (Model Menu |Model Items | Entities, Views etc.)

Use Drag&Drop technique.

To move objects between Workspaces/Models

Use Drag&Drop technique.

Note: Even though it is possible to move objects from a model to a different model of different database platform or version, it is encouraged to use Model Convert function, even for single objects. The Drag&Drop method is faster, but more error-prone, while the Model Convert method is slower, but more robust.

TIP: Combinations of the listed methods are possible - e.g. moving object from Model Explorer in one Model to Model Explorer in another Model.

Snap to Objects

When moving an object on workspace (e.g. entity or relationship line), light blue guidelines appear and help you to align the object more precisely.


The Snap to Objects option is turned on by default - see on the toolbar.

To turn it off

  • Click the Snap to Objects icon on the Grid Toolbar.

or

  • Select Settings Menu | Options | Graphics and uncheck the Snap to Objects checkbox

To turn Snap to Objects off temporarily

Press and hold ALT Key while dragging an object.

Delete Objects

Objects in Toad Data Modeler can be deleted in two ways:

  • Delete Object (Shift+Del) - Deletes an object with all its shortcuts from model.
  • Remove from Workspace (Del) - Removes an object shortcut from Workspace. The object is still accessible in the model, only its graphical representation is deleted.

Scenario

Your model has two Workspaces - WS1 and WS2. You have added a new entity to your model. The entity is places on both Workspaces (assuming the Auto Complete function is enabled). However, you need to have the entity on WS1 only.

Solution: You select the entity on WS2 and simply press Delete. The entity graphical representation on WS2 will be removed, but the entity is still in your model and can be accessed in Model Explorer.

If you would have wanted to delete the entity from your model completely (including all its shortcuts on all Workspaces), you would select Delete Objectoption in Objects Menu (or press SHIFT+Delete).

To remove shortcut of object from Workspace

Select an object (shortcut of object)  on the WS and press Delete.

Tip: You can delete shortcuts in Model Explorer too - select particular shortcut of an object in the Shortcuts folder | right-click | Delete Item.

To delete objects from model (including all its shortcuts)

Select the shortcut of object on Workspace and press SHIFT+Delete.

TIP: You can also delete the objects:

  • In Model Explorer - select an object | right-click | Delete Item.
  • In the Object dialog (Model menu | Model Items | Entities, Relationships etc.) - select the object and click Delete.

When you press Delete in your ER diagram, the following message will display:

Select the action you want to perform.

To set the default Delete options in Toad Data Modeler:

Select Settings | Options | Dialog Boxes | Other tab.

Option Description

Display Dialog

Whenever you press Delete or SHIFT+Delete in your ER diagram, the Delete Confirmation Dialog will pop up and you will be able to select what action you want to perform in particular case.

Remove Graphical Representative of Object

If this option is selected, the Delete will always remove selected shortcut(s) of object from particular Workspace. SHIFT+Delete will have to be used to completely delete an object from your model.

Delete Object

If this option is selected, the Delete will completely delete selected object(s) from your model, including all the object shortcuts. There is no option to only remove selected shortcut(s) of object. (The Delete will replace SHIFT+Delete.)

Find Objects

To quickly find any object on any Workspace

  • Use the Quick Search function (CTRL + F). It helps you find any object swiftly by showing you instant results as you type.

For more information see Quick Search.

To find a specific object on specific Workspace in your large model

  • Use the Find function
    1. Activate the Workspace in Application Window.
    2. From Edit Menu, select Find (SHIFT + CTRL + F shortcut).
    3. Write the name of the searched object to the Object Name box and click OK to find and highlight the object on the Workspace.

 
  • Model Explorer

Right-click an object in Model Explorer | Find on Workspace. The object will be focused and highlighted.

  • Object Viewer

Object Viewer displays a complete lists of all objects in your model. You can find and highlight any selected object (and also its shortcuts) by right-clicking it and selecting Find on Actual Workspace or Find all Shotcuts on Actual Workspace.


Object Viewer

Related Documents