Toad Data Modeler v6.5.5.6 / v6.5.5.7 (x64 / x86)

Whether you’re a data modeler, DBA, or developer, you need a simple-touse data modeling tool for database design, data structure modification and document creation. Enterprise solutions are too expensive and so complicated they often require in-depth training, which interferes with productivity. Toad Data Modeler simplifies database design, maintenance and documentation — at a price your organization can afford.

This powerful data modeling solution supports everyday design and modification tasks, making it easier than ever to:

• Create high-quality logical and physical data models
• Visualize and understand data structures and relationships
• Deploy accurate changes to the data structure
• Document projects for better team communication

FEATURES AND BENEFITS

Perform logical and physical data modeling
Model actual business requirements and transform the model into a perfectly matching technical implementation,
without losing any of the business context in the process.

Compare and synchronize data structures
Compare and synchronize separate models, with complete visual representations of the key differences with intuitive, yet robust model compare and merge wizards.

Generate alter scripts
Generate SQL scripts with “ALTER” commands to synchronize the data model and database.

Reverse engineer
Re-draw the database structure, insert the model into the internal version manager or generate new SQL (DDL) scripts.

Manage versions
Create projects, versions and revisions. Also, add logical and physical models, and other files (for example, test files and
image) to the projects.

Enable extensibility
Modify every object in the scriptable application. Toad Data Modeler is a highly customizable program that adjusts to your organization’s needs or requirements.

Edit on screen
Select a database object from the physical model and simply change it on the screen for significant timesavings. Copy, cut and paste items such as attributes and columns across objects and models. Standard Microsoft Windows drag-and-drop shortcuts can also be utilized.

Customize the user interface
Save a favorite screen design by right-clicking on the screen and choosing “edit.”

New in Toad Data Modeler 6.5.5

Database features

Support for Oracle 18c

• Oracle 18c is now fully supported
• Database settings are placed in Settings | Options | Model | Physical Model | Oracle | Oracle 18c
• Reverse Engineering, Change Script and DDL Script Generation are supported

Oracle 12c Support

New option NOKEEP is supported

• Check NOKEEP in Attribute Properties | Identity
• Check NOKEEP in Sequence Properties

New access drivers for Oracle 12c R2

• In Entity Properties | External Table Properties you can now use ORACLE_HDFS, and ORACLE_HIVE in addition to existing ORACLE_LOADER, and ORACLE_DATAPUMP

New option Segment Creation for Oracle 12c R2

• In Entity Properties | Physical Properties | Segment Creation you can now select Deferred, Immediate or Not Specified

PostgreSQL Support

• Support for Import DDL has been added for Postgres 9.5 and 10
• You now can perform Reverse Engineering from a connection and from a DDL file

EDB Advanced Postgres Server Support

• Support for stored procedures has been implemented
• Support for directories has been implemented
• Support for Nested table type and Varray type for User Data Type has been added

SQL Server 2017 Support

• Support for Graph Tables has been added for Import DDL functionality

Enhancements

External Objects

• Right-click the root of a model and select External Objects | Update All to easily update all external objects

Ordering of Indexes

• Indexes can now be ordered using buttons in Entity Properties or using Ctrl + Up or Ctrl + Down

Selecting Parent and Child Tables in Reverse Engineering

• Select parent and child tables easily using three new buttons in Reverse Engineering Wizard | Tables
• Use right-click menu to select parent or child tables up to 3 level of depth or to infinity

Text Wrapping in Text and Label Rectangle objects

• Double-click Text or Label Rectangle object and check Word Wrap to wrap the text inside

Default names for primary keys

• Set a default name in Settings | Options | Model | Physical Model | Primary Key Default name

Search bar for main menu

• Find any menu option easily by writing its first letters into Jump To