Chat now with support
Chat with Support

Toad Data Modeler 6.2 - Release Notes

Release Notes

Toad® Data Modeler 6.2

Release Notes

Thursday, May 25, 2017

These release notes provide information about the Toad® Data Modeler release.

About Toad Data Modeler

Toad Data Modeler helps organizations create, maintain and document their database systems with an easy-to-use graphical interface into new or existing database structures. Toad Data Modeler enables users to reverse engineer database structures, update models, design and generate SQL, compare models and generate alter scripts, create HTML or RTF reports, in addition to versioning of database designs and creation of to-do lists.

Toad Data Modeler 6.2 is a minor release, with enhanced features and functionality. See New features and Resolved issues for more information.

Toad Data Modeler is released in 32-bit and 64-bit versions. The 64-bit version of the application has a significantly higher memory limit which should resolve several common issues incl. out of memory errors, which occurred when working with complex models.

However, in order to reverse engineer databases that require a client you need a corresponding version of the client, i.e. 32-bit or 64-bit.

 

New Features

New in Toad Data Modeler 6.2

General features

Support for Git

  • Configure Toad Data Modeler to work with Git in Options | Application | Version Control System
  • Set paths to your Git client and working directory for your repository
  • Clone a remote repository easily after setting path to the remote repository, user name and password
  • The values set here will be your default values for setting up new repositories in Toad Data Modeler
  • The following Git commands are displayed in Application View toolbar when you work with a model that is tracked:
Button Description
Version Control System Settings Opens Options page where you can set the Version Control System preferences
Refresh Refreshes file status in Toad Data Modeler
Add to Index Adds the file to the list of tracked files
Remove from Index Remove the file from the list of tracked files
Commit Commits the changes
Push Pushes the committed changes into the remote repository
Pull Pulls the current state from the remote repository
Fetch Fetches information about the current state of the remote repository
Information Displays information about the commit and its author
History Browser Allows you to browse different versions of the file, merge and compare them and create change script

External Objects

  • External objects are objects dynamically linked from another model
  • Right-click a model in Model Explorer or Application View and select External Sources to import external objects
  • Select the source model to import from and check objects you want to use in your destination model
  • Select Window | External Dependencies Explorer to manage imported and exported objects
  • Click Update to update the imported objects if they had been modified in the source model

Syntax Validity

  • SQL Preview tab now highlights errors in SQL script syntax
  • Select Model | Verify Model in the main Toad Data Modeler toolbar and then the Verification Settings
  • Check Syntax Validity to perform syntax checks in SQL Preview for the following objects:
    • Procedure, Function, View, Materialized View
    • User Data Type, Package (Oracle only)
  • Options are available in Options | Model | Physical Model | Verification | SQL Syntax Options
  • Syntax validity check may be disabled in Settings | Options | Model | Physical Model | <database> | Syntax Validity checkbox

Database features

Support for Oracle 12c Release 2

  • The latest Oracle 12c Release 2 is now supported as a physical model, during report generation and DDL script generation

Support for SAP SQL Anywhere 17

  • The latest SAP SQL Anywhere 17 is now supported as a physical model, during report generation and DDL script generation

Support for MySQL 5.7

  • Change Script Generation now supports the following MySQL 5.7 changes:
    • Support for generated columns for ALTER TABLE
    • Support for multiple TRIGGERS

Support for SQL Server 2016

  • Support for Stretch Database (REMOTE_DATA_ARCHIVE) in SQL Server 2016
  • To create a Table for remote data archive see Entity Properties | Stretch Database Properties

NOTE: REMOTE_DATA_ARCHIVE is not supported for Memory Optimized Tables.

  • Enhanced support for history tables:
    • Set System Versioning in Entity Properties | Temporal Table Properties tab

Support for PostgreSQL 9.5

  • Change Script Generation now supports the following PostgreSQL 9.5 changes:
DDL New Syntax
CREATE SEQUENCE IF NOT EXISTS
CREATE MATERIALIZED VIEW

IF NOT EXISTS

Support for SET and RESET of storage parameters log_autovacuum_min_duration, toast.log_autovacuum_min_duration (integer)

CREATE TABLE

Support for SET and RESET of storage parameters log_autovacuum_min_duration, toast.log_autovacuum_min_duration (integer)

CREATE INDEX

IF NOT EXISTS

BRIN method

Support for SET and RESET of pages_per_range parameter in WITH section

Support for SET and RESET of new GIN method parameter gin_pending_list_limit in WITH section

CREATE FOREIGN TABLE INHERITS

Support for Vertica Database

  • You now can work with models of Vertica Database 8.0

Support for Microsoft Azure SQL Database

  • Azure SQL Database V12 is now supported
  • Performance of Script Generation and Alter Script Generation is now much quicker

Enhancements

Naming Convention Enhancements

  • You now can turn case sensitivity off (by default it is on) for Word Replacement
  • To set Case Sensitivity check or uncheck Tools | Naming Convention | Settings | Glossary | Word Replacement
  • You can now select delimiters for Naming Convention

Exporting Views to Excel

  • Support for exporting Views to Excel has been implemented
  • The following table illustrates the modified properties:
Modification Property type

Properties

Unlocked String

Alias

Where

Having

SQL

Comment

Note

BeforeS

AfterS

Boolean GenerateSQLOnly

SelectViewsInText

Locked List

Attributes

From

Order

Group

  • Aliases of entities and attributes are in columns “From” or “Attributes” in a format: “Object AS alias” in an exported file

Model Actions Enhancements

  • You now can sort Model Actions alphabetically or by default (Nature Order)
  • You now can Filter in Model Actions to quickly find what you are looking for

Model Conversion Enhancements

  • You now can enable disabled databases directly from Model Conversion Wizard

Splitting Files in DDL Generator

  • It is now possible to output to several files in Toad Data Modeler DDL Generator
  • To enable check Split Output File in Model | DDL Script Generation | Run or Edit Default Setings

Mapping Attributes and Entities

  • Now you can easily map entities and their attributes in Change Script Generation and Merge Model wizards
  • Click the () button and set the object in the target model you want to map the source object into

Deprecated Features

  • Support of Microsoft Azure SQL Database V2 has been deprecated

Resolved Issues

The following is a list of issues addressed in this release.

Resolved Issue Issue ID
Issue when GRANT statements were generated for unchecked schemas was fixed 2585/3628069-1
Primary keys are now included in table definitions when system_versioning is on 2606
Added support for exporting Views to Excel 2582/3625126-1
Added support for selecting delimiters in Word Replacement 2572/3536502-1
It is now possible to sort alphabetically in Model Actions window 2471
It is now possible to turn of Case Sensitivity off in Word Replacement 2573/3536502-1
You now can split generated DDL into more files 1897/3131260-1
It is now possible to map renamed entities and attributes in Sync & Compare Wizard 1338/2875889-1
Gradients are now printed correctly 2591/3625114-1
Edit Model now displays correct values of Generate Order List for Oracle11g R2 models 2674
Flags are now displayed when adding archived folders to the project 2758
Modification of Data Type Conversion works correctly now 2833/3790032-1
Run Only One Instance of Application setting now works as expected 2896/ 3860203-1
A new confirmation dialog to overwrite Object Type settings in Change Script Generation was created 2897/3860214-1
An error during a PDF report generation was fixed 2915/3870493-1
Error when changing a datatype during conversion of a physical model from Oracle into PostgreSQL was fixed 3119/3964938-1
A new Default values column was added to the Attribute tab in Entity properties 3156/3964938-2
An issue when TDM was installed using an account with administrator permissions and then could not be launched with non-admin users was fixed 3105/3960423
It is now possible to easily convert the whole Gallery from an older format 3027/3909241-1
An error ORA-00904 on trying to reverse engineer Oracle 9i: was fixed 2986/3900630-1
Microsoft JScript runtime error during generation of indexes Change Script in MySQL 5.6 was fixed 2945/3879943-1
Quick Search was implemented for Model Manager 2551
Reverse Engineering can now be run from JSCRIPT (CreateCSStringHashLists has been made available) 2594
You now can enable disabled databases directly from Model Conversion Wizard 1930
Change Script Generation is now available for MySQL 5.7 2316
New history table settings in Entity Properties | Temporal Table Properties tab were implemented 2704

Known Issues

The following is a list of issues, including those attributed to third-party products, known to exist at the time of release.

Issue Issue ID
When using DPI settings higher than 125%, grids in dialogs are not scaled correctly 2044
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating