Release Notes

Quest Software's 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 3.x represents a major increase in the capabilities in comparison to Toad Data Modeler 2.x. It's a much more powerful database design tool bringing users many new efficient and useful features that are accompanied by completely new, clear and intuitive user interface.

New in This Release

Toad Data Modeler 3.4.15 is a patch to version 3.4.14. No new features have been implemented in this version.

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in Toad Data Modeler 3.4.14.

Feature	Resolved Issue	CR #
Toad Data Modeler 2.x Model Import	Rolenames are imported properly now. (See the Caption box in Toad Data Modeler 3.x.)	57 364
Toad Data Modeler 2.x Model Import	MS SQL Server 2005 - XML error occurred during loading of .dmx file when an attribute had the Maximum storage size for varying types is max option selected twice - in its Properties dialog and in its User Data Type too. Fixed.	57 358
Alter Script	Problem during alter script generation and model conversion when FK mapping was used in a model. The attributes were not converted properly. Fixed.	56 216
Model Conversion	LER - PER conversion to Oracle model. Rule in domain (LER model) has changed to a check constraint after conversion. Checkbox Generate was clear by default in the check constraint, which was wrong. Problem fixed. The Generate checkbox is selected by default now.	60 384
	LER – PER conversion: NN property in child attribute was missing although Mandatory parent and synchronization were enabled. Fixed.	58 283
	LER to PER conversion: Cardinality was not converted properly if Mandatory specification in logical model between left and right side was changed. Fixed.	51 804
Model Update	Shortcuts of relationships were not created on the Workspace. Fix: Shortcuts of objects are automatically added to Workspaces where Auto Complete option is selected.	60 873
Physical Modeling	Changes in domain definition (removed default value) were not propagated in attributes with this domain. Fixed.	60 426
Logical Modeling	When you make a copy of entity on Workspace via CTRL+C, CTRL+V, the copy will be placed on the original entity with an offset.	60 545
	Access Violation error when a domain was selected for an attribute in the Attribute Properties dialog. Fixed.	58 294
	Model Properties option available in Model menu or context menu in Model Explorer or Application View.	43 261
Reports	Images of Workspaces are sorted alphabetically. Note: The checkbox Sort Objects Alphabetically must be selected.	63 651
	Error 'Canvas doesn't allow drawing' fixed.	63 212
	Order of objects generated in the report has been modified. The objects are now ordered alphabetically regardless of character case.	61 515
	Possibility to generate HTML, RTF, PDF reports for PER model and HTML, RTF reports for LER model only for the selected Workspace. Related enhancements/changes: 1. Existing combo-box in HTML report has been renamed to Select Workspace. This combo-box has been added to RTF report. The item All Workspaces is selected in this combo-box by default. 2. Checkbox Generate All ER diagrams (all workspaces) has been replaced with a new checkbox Generate All Model Objects. 3. If you select a particular workspace and select also the Generate All Model Objects checkbox, the result will be the following: image of ERD of the selected workspace plus all model objects will be generated in the report. 4. If you select a particular workspace and clear the Generate All Model Objects checkbox, the result will be the following: image of ERD of the selected workspace plus only objects that exist on the workspace will be generated in the report (e.g. tables, relationships, views etc.). The report will also contain all model objects that cannot be placed on workspace (e.g. User Data Types, Procedures etc.) 5. If All Workspaces item is selected in combo-box, the Generate All Model Objects checkbox is selected automatically. Images of all workspaces of the model plus all objects of the model will be generated in the report.	58 110
	Alter reports in RTF format in PER models	47 092
XSL Transformation	Possibility to save XSD file directly from the XSL Transformation dialog – see the Save XSD File As button.	55 005
Version Manager	After Check Out of version, Model Explorer of this version will open and dock automatically.	51 307
GUI Enhancements	Highlighting a relationship line on the Workspace when you select caption of the relationship.	60 717
	Double-click the shortcut name of relationship in Model Explorer highlights the relationship line on the Workspace.	60 644
	Notes – Automatic wordwrap in object Note.	60 635
	Edit \| Align \| Align Left – Captions of relationships were not aligned properly. Fixed.	60 579
	Printing problem – The Enlarge value defined in the Page Format dialog was ignored when customer selected the Print Range option in the Print dialog. Fixed.	60 576
	Information on the location of the currently opened model on the main application window.	60 473
	Right-click the particular Workspace in the Application View: Delete Item option has been renamed to Delete Workspace.	60 471
	Autolayout after option Fill Parent and Child Objects (entity right-click option on WS). The objects added to the entity will be arranged properly.	60 440
	Ampersand ‘&’ can be displayed in Note object on Workspace.	60 434
	Settings of Default Data Type in the Options dialog were not preserved although they were confirmed. Bug fixed.	60 139
	It was not possible to change the Pen Width values in Options dialog. Fixed.	60 138
	Page Format – Wrong page settings for A4 format when millimeters were selected as a default unit of length. Fixed.	58 708
	Bug during editing logical names of views, materialized views and relationships via the Inplace editor. The changed caption changed also physical name of the object, which was incorrect. Fixed.	58 166
	Problem description: When reverse engineering a model and using the IDEF1X notation, the attributes ordering became inconsistent. Choosing IE showed the correct ordering. Problem fixed.	58 061
	Preview was displayed incorrectly for landscape page orientation and option Fit to Page selected. Fixed.	57 701
	Entity Properties form in child entity \| Attributes tab. When you select a PFK or FK attribute and then other attributes to delete them, the Delete button will be disabled as it is not possible to delete PFK/FK attributes.	57 641
	The Add Selected Objects to Workspace dialog has been resized (enlarged). Also, width settings remain preserved when you reopen the dialog.	57 210
	During calling CreateWorkspaceLineByParentobject , the initialization of line was not performed. Fixed.	56 957
	Possibility to select a color for keys (PK, FK, PFK). Select Settings \| Options \| Physical Model \| Entity tab \| Attribute Colors area.	55 307
	Entity Properties form \| Attributes tab \| Data Type column of particular entity. When you press F2, you can select a data type or domain or user data type. Domains and User Data Types are graphically distinguished in the list.	53 955
	SQL Preview tab did not refresh after selecting another item from the Object navigator box. Fixed.	46 080
MS Access 2000-2003	Reverse Engineering – New checkbox Load Unique Indexes as Alternate Keys. Select it to load unique indexes as alternate keys.	60 499
MS SQL Server 2008	Import of DDL – Command CREATE SPATIAL INDEX is now parsed and therefore loaded to particular places.	63 211
MS SQL Server 2008/2005/2000	DDL script generation: DROP DEFAULT didn't contain schema. Fixed.	62 470
	Reverse engineering: New checkbox Load Tables Referenced by Selected Tables. When it is selected, the following tables will be loaded: - those that user selects in step Tables, plus - those that user will not select in step Tables, however they will be loaded as they are related to the selected tables via relationships.	60 277
	Loading of DDL script – for database MS SQL Server 2005 and MS SQL Server 2008.	57 621
	LIVE Reverse Engineering for MS SQL Server 2000, 2005 and 2008.	57 355
MySQL	Reverse engineering of MySQL 5.1 – Relationships were not loaded. MySQL problem - If parameter lower_case_table_names for MySQL is set 0 or 2, then command SHOW CREATE TABLE returns for relationships a parent table name in lower case although it is in upper case. This caused a problem during searching of the parent table during reverse engineering in Toad Data Modeler. Fixed.	62 679
MySQL	Autoincrement problem in attributes with Char data type. Fix: Autoincrement is not generated in SQL/DDL code, reports and alter scripts for data types that do not support autoincrement.	58 066
Oracle 11g	Alter script Oracle 11g problems: 1. Error during alter script generation for Oracle 11g models - change of parameter from BYTE to CHAR for Char and Varchar2 data types. Problem Description: A change was made in a domain. If this changed domain was used in attributes in the models that were compared in Convertor, an error occurred during the alter script generation. Fixed. 2. Change of data type at Virtual Column generated the MODIFY clause in alter script. In the MODIFY clause, also Expression of Virtual Column was used. However, during a change of column that is Virtual Column, the Expression must not appear provided that there is not any change. Fix: Expression is not written out, only the change of data type is generated in the alter script. 3. Change of Expression in Virtual Column when the column is NOT NULL in the old model (in the model that you like to update) was not executed. Fix: Before this change, the NOT NULL constraint will be cancelled, then the change of Expression will be executed and during this, the NOT NULL will be set up again (or will not be – according to whether it is set up in the new model or not).	59 388
Oracle 11g	Reverse engineering – Only attributes of the first loaded table were loaded during RE. Bug fixed.	56 958
Oracle 10g	Import of DDL script: Error: REDataMigratorDDLOR Description: ‘null’ is null or not an object. Problem occurred while adding foreign keys where columns in the References part were not defined. Fixed.	57 702
Oracle 11g, 10g	Reverse Engineering – LOB Parameters of XMLType are loaded now. In the RE Wizard, see these checkboxes: Load XMLType Column Properties for Tables – If it is selected, XMLType will be loaded. Load LOB Storage Parameters for Tables/Materialized Views - If it is selected, LOB parameters of table columns and LOB parameters of XMLType parameter will be loaded. XMLType parameters and their LOB parameters are displayed in Entity Properties form \| Table Properties tab. Example: XMLTYPE "A" STORE AS CLOB (TABLESPACE "USERS" CHUNK 8192) Note: The table must have an attribute of XMLTYPE data type.	56 647
Oracle 9i	Alter script Oracle 9i – problem during alter script generation of named NOT NULL constraints. Fix: Named NOT NULL constraints are generated after deletion of temporary table. NOT NULL constraints that are not named are generated in the CREATE TABLE statement of the temporary table.	64 291
Oracle 11g, 10g, 9i	Import of DDL (via Live RE or RE Wizard) – minor bug fixes and enhancements. Materialized View is now parsed to particular boxes in the Materialized View Properties dialog (in previous versions the complete command CREATE MATERIALIZED VIEW was loaded on tab SQL).	63 148
	Reverse engineering – Problem occurred when user used in his schema a table name that was identical with system table name. Problem fixed.	61 250
	LIVE Reverse Engineering – Triggers on tables and views were not loaded. Fixed.	58 115
	DDL Script generation + Reverse engineering – added support of External Tables. To define a table as External Table, open the Entity Properties form \| Physical Properties tab and select the External Table (Organization External) checkbox. Then the External Table Properties tab will occur on the form.	57 242
	Reverse Engineering – Information on system tables to which user does not have access or SELECT privilege will be written out in the Log area of the RE Wizard. There can be one of the following outputs: 1) Missing access to system table ALL_TABLES. 2) Missing privilege SELECT on system table ALL_TABLES.	55 604
	Oracle Directory Objects supported. Open Model Explorer and see new item Directories where you can define the Oracle Directory Objects and where the Oracle Directory Objects are loaded during reverse engineering. Open the Directory dialog to define a name and Full Path Name as e.g.: C:\oracle\admin\oracle12	43 191
PostgreSQL 8.3, 8.2, 8.1	Rewrite Rules supported – see the new item in Model Explorer Notes: - In the Rule Properties dialog, you can select whether the rule relates to view or entity. - In reports, Rewrite Rules will be generated for entities and views provided that the Rewrite Rules, Entities and/or Views checkboxes are all selected in OTPs (step What to Report in the Report wizard). - During reverse engineering only those Rewrite Rules that relate to the loaded entities and views will be reversed.	58 545
Sybase ASE 15, 12.5	Reverse engineering - Error during loading permissions: Source: CS3 - Internal error Script: REDataMigratorDBAS15 Description: '' is not a valid GUID value Fix: Now instead of the error, information on which permissions were not loaded will be written out in the Log area (Note: TDM does not load all permissions during RE.)	59 804

Known Issues

The following is a list of issues known to exist at the time of Toad Data Modeler release.

Upgrade and Compatibility

Toad Data Modeler 3.x allows you to open DM2 files and DMX files of Toad Data Modeler 2.x. (DMX file is a DM2 file in XML format.) This applies only to models of database systems that are supported by both applications - Toad Data Modeler 2.x and Toad Data Modeler 3.x.

It is not possible to open models created in Toad Data Modeler 3.x in Toad Data Modeler 2.x.

Do not open and resave models originally created in a higher version of Toad Data Modeler (e.g. in v. 3.4.15) in lower version of Toad Data Modeler (e.g. v. 3.3.8).

System Requirements

Before installing Toad Data Modeler, ensure your system meets the following minimum hardware and software requirements:

Global Operations

This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.

This release is Unicode-enabled and supports any character set. In this release, all product components should be configured to use the same or compatible character encodings and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.

This release has the following known capabilities or limitations: Localized support for HTML and RTF/PDF reports in several languages will be distributed via Modeling Community http://modeling.inside.quest.com. Languages: Chinese (Simplified and Traditional), Czech, Hebrew, Hindi, Punjabi, Russian and Spanish.

Getting Started

Contents of the Release Package

Installation Instructions

Toad Data Modeler Trial version limitations: 15 -day trial period and multiple features limited to a maximum of 25 entities.

To install Toad Data Modeler successfully, Administrator privileges are necessary.

For More Information

Contacting Quest Software:

Contacting Quest Support:

Quest Support is available to customers who have a trial version of a Quest product or who have purchased a commercial version and have a valid maintenance contract.
Quest Support provides around the clock coverage with SupportLink, our web self-service. Visit SupportLink at http://support.quest.com.

View the Global Support Guide for a detailed explanation of support programs, online services, contact information, and policy and procedures.

This document contains proprietary information protected by copyright. The software described in this document is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software, Inc.

If you have any questions regarding your potential use of this material, contact:

Trademarks

Quest, Quest Software, the Quest Software logo, Aelita, Akonix, Akonix, AppAssure, Benchmark Factory, Big Brother, ChangeAuditor, DataFactory, DeployDirector, ERDisk, Foglight, Funnel Web, GPOAdmin, I/Watch, Imceda, InLook, IntelliProfile, InTrust, Invertus, IT Dad, I/Watch, JClass, Jint, JProbe, LeccoTech, LiteSpeed, LiveReorg, MessageStats, NBSpool, NetBase, Npulse, NetPro, PassGo, PerformaSure, Quest Central, SharePlex, Sitraka, SmartAlarm, Spotlight, SQL LiteSpeed, SQL Navigator, SQL Watch, SQLab, Stat, StealthCollect, Tag and Follow, Toad, T.O.A.D., Toad World, vAnalyzer, vAutomator, vControl, vConverter, vEssentials, vFoglight, vMigrator, vOptimizer Pro, vPackager, vRanger, vRanger Pro, vReplicator, vSpotlight, vToad, Vintela, Virtual DBA, VizionCore, Vizioncore vAutomation Suite, Vizioncore vEssentials, Xaffire, and XRT are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks used in this guide are property of their respective owners.

Disclaimer

The information in this document is provided in connection with Quest products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest does not make any commitment to update the information contained in this document.

Platform	Pentium IV
Memory	Minimum 256 MB
Hard Disk Space	100 MB
Operating System	Microsoft Windows 2000 Professional Edition (Service Pack 4) Microsoft Windows XP 32-bit Microsoft Windows XP 64-bit Microsoft Windows Vista 32-bit Microsoft Windows Vista 64-bit
Additional Software	none

Email	info@quest.com
Mail	Quest Software, Inc. World Headquarters 5 Polaris Way Aliso Viejo, CA 92656 USA
Web	http://www.quest.com