1588.01-tdm-physical-model.png-550x0

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.

 

08-entity-attribute.png-550x0
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.

 

05-verification.png-550x0
Model Verification

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

 

7357.03-sql-code.png-550x0
SQL Code Generation

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

 

4212.02-re.png-550x0
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.

 

7455.04-reports.png-550x0
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.
  • Responsive layouts in HTML reports.

 

3632.12-find.png-550x0
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

 

5126.06-sync.png-550x0
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.
  • Possibility to save settings & items selection.

 

2161.07-convert.png-550x0
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.
  • Possibility to run conversion again with already saved settings.

 

09-macros.png-550x0
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.

 

10-export.png-550x0
Excel Export/Import

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

 

11-naming-conventions.png-550x0
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.
  • Model Actions for quick execution of synchronization tasks.

 

Start the discussion at forums.toadworld.com