Product Features - Toad Data Modeler Wiki - Toad Data Modeler - Toad World

Product Features

Database Modeling

Support for three different types of models:

  • Logical model with support for inheritance.
  • Universal model (Generic physical model).
  • Physical model (+40 platforms) with Logical/Physical views.
  • Newly supported platforms:
    Microsoft SQL Server 2014 and
    DB2 v. 10.5 LUW.

Basic features

  • Workspaces - allows you to split larger model.
  • Autolayouts - for automatic rearrangement of objects in diagram.
  • Object Alignment, Grid, Snap to Objects...
  • Coloring, Arrangement and other common features.

Visual Creation of Databases

  • Entity Relationship Diagrams.
  • Database objects defined visually.
  • Automatic migration of foreign key attributes in physical model.
  • Automatic mapping of existing attributes.
  • Automatic creation of indexes to foreign keys.
  • See VIDEO

Model Verification

  • Find errors in your model.
  • Navigate to problematic objects.
  • Use Quick Fixes to fix problems at once.

    SQL Code Generation

    • Generate complex database platform specific DDL scripts.
    • Define detailed settings for SQL code generation.
    • Open generated script in associated application.
    • See VIDEO

    Reverse Engineering

    • Create connections to your databases.
    • Create a new model based on existing database structure.
    • Import from SQL files is supported for many database platforms.
    • See VIDEO

    Reporting

    • Generate reports in HTML, RTF or PDF format.
    • Use XSL Transformation to create custom reports
    • Export diagram to image file for printing purposes
    • Export metadata to excel.
    • See VIDEO
    • New: Responsive layouts in HTML reports.

    Quick Search

    • Press CRTL+F to open the Quick Search form.
    • Use standard search as well as advanced techniques, including:
      • Word recognition
      • Camel case
      • Dot notation
      • Wildcards

    Synchronization

    • For majority of supported platforms, synchronization features are available.
    • Compare models or model with database and generate alter scripts (change scripts).
    • Update model from database.
    • See VIDEO
    • New: Possibility to save settings & items selection.

    Model Conversion

    • Convert logical model to selected physical model, e.g. Oracle or SQL Server model.
    • Convert physical model to another target platform. Create model for Oracle 12c and convert it to PostgreSQL 9.2 etc.
    • New: Possibility to run conversion again with already saved settings.

    Macros and Scripting

    • Use in-built macros or create your custom macros with additional functionality.
    • Modify objects in batch mode.
    • Create simple forms for input definitions.
    • Use scripting for fast JavaScript code execution.

    Excel Export/Import

    • Export metadata to Microsoft Excel.
    • Do changes in Excel.
    • Import the modifications to model file.

    Advanced Features

    • Naming Conventions - define restrictions and make sure your model doesn't contain any naming convention violations.
    • Default Values - allows you to specify how new objects will be named.
    • Gallery - for storing frequently used parts of models.
    • Support for SVN
    • Refactoring Utility
    • Schema/Owner Assignment Utility
    • Templates for stored procedures and functions
    • ToDo List and more.
    • New: Model Actions for quick execution of synchronization tasks.

    #

    11064 1 /
    Follow / 27 Oct 2016 at 10:55pm

    Sure wish I could figure out how how to get the default values to work!  <> keeps resolving to an empty string.