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

Microsoft SQL Server 2017

Entity

  • New node and edge (graph) tables are now supported
  • Click Add Atribute to add graph table specific attributes. In Attributes, these will be called using $node_id and $edge_id, $from_id, $to_id for node and edge tables respectively

Details

  • CREATE EXTERNAL LIBRARY: External libraries are not supported
  • CREATE OR ALTER: this clause is now supported for procedures, views, functions, and triggers (with exception for Change Script Generation where only Alter or Drop and Create are used)

Reverse Engineering

Available Data Providers are:

  • Connection via ADO
  • Native Connection

Connection via ADO:

Native Connection:

Reverse Engineering Settings

  • Check Graph Table Columnsto include graph table columns $node_id", "$edge_id", "$from_id", "$to_id in your RE

Script Generating

Note: To generate the table, column descriptions for SQL Server db in Toad Data Modeler, schema/owner has to be defined. Please see the Entity Properties form | General tab and from the Schema box select a schema or click the icon on the right to open the Schema dialog and define a new schema, then select it for the entity.

MySQL 5.0

Entity

For Row Format item, it's possible to select some of these options:

  • Default
  • Dynamic
  • Fixed
  • Compressed
  • Redundant
  • Compact

Properties Character Set and Collation must be identical for parent and child tables provided that at least one parent attribute is of a text data type. If the properties are not identical, a warning message is returned during model verification.

Attribute

Comments box on tab General - The text written in the Comments box on entities and attributes is generated in final DDL script.

Model Conversion from MySQL to SQL Server and Oracle

MySQL Enum data type is converted to Char data type, a check constraint for the attribute is created, the parameter is preserved (see the SQL tab of the Check Constraint Properties dialog).

   

Relationship

Foreign keys are supported only by tables of the InnoDB type.

 

Index

The following types of indexes are supported:

  • Default
  • BTREE
  • HASH

Fulltext indexes are supported only by tables of type MyISAM.

 

Trigger

Trigger Event options:

  • INSERT
  • UPDATE
  • DELETE

Trigger Time options:

  • BEFORE
  • AFTER
 

User Data Types, Dictionary Types

In MySQL 5, User Data Types and Dictionary types are not available.

Databases

Related Documents