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

Merge Models

Toad Data Modeler offers you two options to merge your models:

  • Simple Model Merge - allows you to merge physical models quickly due to skipping several settings dialogs and Model Comparison. The target model will always be overwritten.
  • Model Merge in the Model Actions - allows you to see differences between two models, select particular items to merge and merge the models either to already existing model or to a new model.
  • Example: You work with several models. Use Model Merge to compare the models and merge them either to an existing model, or to a new model altogether.

How to Merge Models

Model Merge can be found in Model Actions (Window Menu | Model Actions), or in Model Menu | Merge Models | Run.

  • In the first step select either an opened model or a model from a file.

note: The selected model has to be of the same database platform and version. You cannot compare DB2 10.5 and MySQL 5.1 models, or MySQL 5.1 and MySQL 5.5 models.

  • The next dialog presents you with a couple of setting related to Model Comparison. When you're done editing the options, click on Next.

  • Now you have to choose what types of objects will be included in the comparison. If you wish to select objects in more detail, click on Detailed Settings.
    • Entities and attributes can be easily mapped here in the last step
    • Double-click the button () to map an entity or attribute to a target entity or attribute
    • The Description column displays the current state of the object. Objects can be unmapped

  • You are now presented with Compare Tree dialog displaying all differences between the two given models. Check or uncheck items to select what objects will be merged.

  • Check the Review screen which show you the changes for each object type. If you want to merge models into a new model, check Merge to New Model and enter its name.

TIP:If you plan to do this action again in the future, you might want to click the Save Action button to save this Action Definition. See Model Actions for more information.

Compare Tree Overview

Option Icon Description
Import Selection Import selection from a saved file.
Export Selection Save selection to a file.
Verify

Runs the verification process.

The verification might return a warning . Details are available in Verification Log.

Check All Checks all items.
Uncheck All Unchecks all items.
Check All to Add Checks all items that exist in the Source model, but not in the Target model (CREATE).
Check All to Remove Checks all items that do not exist in the Source model, but exist in the Target model (DROP).
Check All to Modify Checks all items that exist in both models and are different (ALTER).
Wildcard Filter Opens the Wildcard Dialog where you can define settings for bulk selection/deselection of the Action box of the items listed on page Select Items.
Refresh Necessitated Items

Some objects are related together (e.g. entity and domain, entity and relationship). In case you uncheck an object or property in Select Object Types step and a related object or property is selected, the unchecked object or property will be automatically selected too.

E.g. You uncheck a domain in Select Object Types but you keep an attribute of the domain type checked for conversion. In the next screen the domain will be selected for conversion (and highlighted in gray). This is because of its relationship with the attribute, which cannot exist without the domain.

If you uncheck the attribute, the domain will still be checked for conversion. This is where you use this button. It inspects all checked objects and removes the domain highlighted in gray since the attribute is no longer checked. That means the domain is no longer necessary, since it has no relationships with currently checked objects and you unchecked it in Select Object Types step.

Display options for objects

Compare Tree will show only:

  • Show All Objects
  • Show Equal Objects
  • Show Different Objects
Display options for properties Compare Tree will show only:
  • Show All Properties
  • Show Equal Properties
  • Show Different Properties

Source

- The updated or modified model.
Target - The model for which you want to generate change script.
Operation -

Check this checkbox to generate change script for the difference.

Uncheck this checkbox to not generate change script for the difference.

Default selection: Default selection of the Action checkboxes depend on your settings on page Settings in the Options for Default Selection of Items area. If you select all the options in this area, the Action checkboxes will be selected for all changes (CREATE, DROP and ALTER) by default.

 

Compare Tree Icons

Difference between original model and Target model.

This object exists in original model but does not exist in Target model.

This object is missing in original model but exists in Target model.

Right-click menu

Right-click any item to display the following menu:

Option Description
Check All Children Checks the Operation checkbox of all children items.
Uncheck All Children Unchecks the Operation checkbox of all children items.
Check All Children to Add

Checks the Operation checkbox of children items that exist in Source model but not in the Target model ( items) to generate the CREATE statement.

Check All Children to Remove Checks the Operation checkbox of children items that are missing Source model and exist in Target model ( items) to generate the DROP statement.
Check All Modified Children Checks the Operation checkbox of children items where properties differ (items) to generate the ALTER statement.
Uncheck All Children to Add Unchecks the Operation checkbox of children items that exist in Source model but not in the Target model ( items) to not generate the CREATE statement.
Uncheck All Children to Remove Unchecks the Operation checkbox of children items that are missing Source model and exist in Target model ( items) to not generate the DROP statement.
Uncheck All Modified Children Unchecks the Operation checkbox of children items where properties differ (items) to not generate Change Script for this change.
Wildcard Filter Opens the Wildcard Dialog where you can define settings for bulk selection/deselection of the Operation box of the items listed on page Select Items.
Expand All Children Expands all sub-items of the selected item.
Collapse All Children Collapses all sub-items of the selected item.

Simple Model Merge

This feature allows you to merge two physical models very quickly. However, in comparison to the model merge in the Sync & Convert Wizard:

  • You cannot select particular items for the model merge (e.g. not to merge particular entity). You can select only Object Types and Properties for the model merge.
  • The target model will always be overwritten.

To use the Simple Model Merge feature

  1. Open both models that you want to merge.
  2. Make the modified (updated) model active in the Application Window (source model).
  3. Select File |Synchronization | Simple Model Merge.
  4. From the To Model box, select a model that you want to update (target model). - This model will be overwritten.
  5. See other options.
Option Description

To Model

Select a target model.

More>>

Click this button to see and modify Object Types and Properties for the model merge.Object Types and Properties - OTPs

Close after Merge

Closes the Merge dialog after the process is finished.

Merge

Executes the process of model merge.

Close

Closes the Merge dialog.

  1. Click Merge.

Model Conversion

Data Type Conversion Settings

Before you start the conversion process, you can set conversion settings for data types.

  1. Enable Expert mode: Select Settings | Options | General | check the Expert Mode checkbox.
  2. From the main menu, select Expert Mode | Expert Mode Settings | Data Type Conversion Settings.

  1. In the Source and Destination boxes choose the desired databases.
  2. Press to display available data types. Click to view only exceptions.

You can see a list of data types of source model that will be converted to data types in destination model.

Example: Oracle Blob data type will be converted to Microsoft SQL Server 2012 model as Image data type. You can change the destination model data type.

Note: The modified database conversion settings are saved to DataTypeConversion.txn file stored by default in: C:\Users\*username*\AppData\Roaming\Quest Software\Toad Data Modeler\*Installation name*\Configs. If you want to restore the original conversion settings, you can simply delete this .txn file.

  1. Confirm OK.

Execute Script

If you want to use your own script for data type conversion, click the Go to Exception Script button. A dialog offer you to create a new script. Confirm and the newly created script will be shown in Script Editor, where you can edit it as you like.

Example:

function Convert(){

  var Log = System.CreateObject('Log');

  Log.Information('Konverze');

  Log.Information('Input MD: '+ InputModelDef.Abbrev );

  Log.Information('Output MD: '+ OutputModelDef.Abbrev );

  

  Log.Information(InputDataType.ConversionID.Code);

         

  var outDT                                     

  if (InputDataType.ConversionID.Code == 'C_X'){

   Log.Information('HERE');

    for( i = 0; i < OutputDataTypes.Count; i++ )

    {

      outDT = OutputDataTypes.GetObject( i );

      Log.Information( outDT.Name );

      if (outDT.Name=='Box') {

        return(i);

      }

    }

  }  

  

  return(0);

}

Related Documents