Toad Data Modeler

Version 4.1.5

Release Notes

26 August, 2011


Contents

Welcome to Toad Data Modeler

New in This Release

Resolved Issues and Enhancements

Known Issues

Upgrade and Compatibility

System Requirements

Global Operations

Getting Started

For More Information

 

Welcome to Toad Data Modeler

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.


New in This Release

Review the following sections for new features and updates in this release:

 

General

Support for Ingres 10.0

Support for DB2 z/OS v.10

Changes in comparison with DB2 z/OS v.9

And several minor changes have been implemented.

 

Generator

New checkbox Append to File was added in What to Generate tab.

When the option is checked, the extra code is appended to the original file and nothing of the original file is overwritten.

 

Gallery

Gallery has been updated and contains new objects.

Also new option Add to Active Model has been added in the object popup menu.

 

Macros

New Macros were added in Library. There are two new packs of Macros:

 

Reports

In HTML reports, the content of the Description tab of Workspace Properties added at the top of every workspace displayed under the ER Diagram tab.

 

GUI

View Relationships are now highlighted when moving mouse over the particular Caption.

Right-click relationship Caption menu functionality improved by adding new options Move Caption to Parent and Move Caption to Child.

In View Properties, Relationship alias is now displayed along with the Entity Name.

Schema Name displayed as the first part of the name of the object in the Model Explorer when the Display Mode is set to Full Names.



Resolved Issues and Enhancements

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

Feature Resolved Issue CR ID
Alter Script Even when Workspaces are unchecked in Selected OTPs, they still appear in differences comparison chart - Fixed. 88508
Even when Before/After script of procedures and functions is unchecked in AlterScript generation Wizard, it is still generated to AlterScript - Fixed. 88513
Series of errors after AlterScript generation for MySQL dbs - Fixed. 88609
Alter Script/Merge Models Wrong result of Merge Models/AlterScript generation with SQL Server 2008. It doesn't consider which model is left and which is right and sets the value of the variable to 1. 86641
Export to Graphic File Add the checkbox Open Folder After Export to open the folder with the exported graphics after processing. 86639
The file name offered is the name of the model. You are not prompted on overwriting the previously exported file/image. 86722
When other than the system drive C: selected for export, multiplied slashes appear and the path is invalid - Fixed. 88446
Gallery Doubled Domain when added from the Gallery. 86245
Generator Malfunction of Append to File- the original model is being overwritten - Fixed. 88503
LER Logical model- Cardinality does not allow optional (1-1) relationships- not able to set a relationship cardinality to be 1..1 - 0..1. 87109
Model Explorer Full Names shown also in Model explorer now. 84909
Ordering columns Add possibility to reorder columns via scripting. 84631
RE Wizard In RE Wizard (and Model Update), when Load Alias is not used and you only select the Alias and click next, default RE values are used- confusing. 86749
Relationships Application of the default value of Mandatory Parent on non-identifying relationships. 86642
Popup menu- Move Caption to Parent and Move Caption to Child options added. 61162
Reports In HTML reports, the content of the Description tab of Workspace Properties added at the top of every workspace displayed under the ER Diagram tab. 85208
Reverse Engineering Error 'null' is null or not an object when RE 11.2.0.2 database DDL. 87211
Version Manager Includes options that didn't work, because they were not finished - Fixed. 85688
Workspace Added option in Add Selected Objects to add relationships for the tables added in workspace. 86242
File management Management and handling of read-only files- error thrown upon saving a file - Fixed. 84910

Known Issues

There aren't any known issues at the time of this release.

Feature Known Issue Defect ID
n/a n/a n/a

Upgrade and Compatibility

Toad Data Modeler 4.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.) and all file types of TDM 3.x. This applies only to models of database systems supported by both applications - Toad Data Modeler 2.x / Toad Data Modeler 3.x and Toad Data Modeler 4.x.

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

Do not open and re-save models originally created in a higher version of Toad Data Modeler (e.g. in v. 4.1.5) in a lower version of Toad Data Modeler (e.g. v. 3.6.6).


System Requirements

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

Platform Pentium IV
Memory Minimum 256 MB , 1 GB recommended
Hard Disk Space Minimum 160 MB, 320 MB recommended
Operating System

Microsoft Windows 2000 Professional Edition (Service Pack 4)

Microsoft Windows XP (32-bit or 64-bit)

Microsoft Windows Server 2003 (32-bit or 64-bit)

Microsoft Windows Vista (32-bit or 64-bit)

Microsoft Windows Server 2008 (32-bit or 64-bit)

Microsoft Windows Server 2008 R2 (64-bit)

Microsoft Windows 7 (32-bit or 64-bit)

Database Server

DB2 UDB v. 8 (LUW), 9.0 (LUW), 9.5 (LUW), 9.7 (LUW) 

DB2 z/OS v. 9, v.10

Ingres 9.3, 10.0

Access 2000/2002/2003/2007/2010

SQL Server 2000, 2005, 2008

SQL Azure

MySQL 5.0, 5.1, 5.5

Oracle 9i, 10g, 11g R1, 11g R2

PostgreSQL 8.1, 8.2, 8.3, 8.4, 9.0

Sybase ASE 12.5, 15, 15.5

Sybase SQL Anywhere 11

Cloud Database Server

Oracle databases running on Amazon EC2

SQL Server running on Microsoft SQL Azure

MySQL database running on Amazon RDS

Additional Software

Adobe Acrobat Reader 7.0 or later (for viewing the Installation Guide)

Virtualization Support

Review the following information about using Toad Data Modeler in virtual environments:

Application

Toad Data Modeler has been tested for Citrix support on Windows XP using the XenApps 5.0 Server.

Desktop (VDI)

Toad Data Modeler has been tested with the following:

Quest vWorkspace 7.0 running on Windows XP (32-bit)

Note: Problem during print on virtual printer - The problem occurs only in case of print from local machine (all printers from local machine are visible on vWorkspace). If the virtual printer is installed on vWorkspace directly, the problem doesn't occur.

Server

Toad Data Modeler has been tested with VMware Server 2 running on Windows 7.

Note: Toad Data Modeler may work in virtualization environments other than the ones in which it was tested.


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.

The release is localized to the following languages: Chinese (Simplified), Chinese (Traditional), Czech, Hebrew, Italian, Portuguese (Brazil), Russian, Spanish.

This release has the following known capabilities or limitations: Localized support for HTML and RTF/PDF reports in several languages will be distributed via TDM Community.

http://modeling.inside.quest.com/pageloader.jspa?sbinPageName=downloaddictionaries.htm&sbinPageTitle=Download%20Dictionaries

Chinese (Simplified and Traditional), Czech, Hebrew, Hindi, Punjabi, Russian, Spanish, Brazilian Portuguese and Italian


Getting Started

Contents of the Release Package

The Toad release package contains the following products:

  1. Toad Data Modeler version 4.1.5
  2. Product Documentation, including:

Installation Instructions

Refer to Installation Guide for installation instructions.

Notes:

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

Get the latest product information, find helpful resources, and join a discussion with the Toad Data Modeler Quest team and other community members. Join the Modeling community a http://modeling.inside.quest.com.

Contact Quest Software

Email

info@quest.com

Mail

Quest Software, Inc.

World Headquarters

5 Polaris Way

Aliso Viejo, CA 92656 

USA

Web site

www.quest.com

See our web site for regional and international office information.

Contact Quest Support

Quest Support is available to customers who have a trial version of a Quest product or who have purchased a Quest product and have a valid maintenance contract. Quest Support provides unlimited 24x7 access to SupportLink, our self-service portal. Visit SupportLink at http://support.quest.com.

From SupportLink, you can do the following:

View the Global Support Guide for a detailed explanation of support programs, online services, contact information, policies and procedures. The guide is available at: http://support.quest.com.


© 2011 Quest Software, Inc.

ALL RIGHTS RESERVED.

This guide contains proprietary information protected by copyright. The software described in this guide 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.

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.

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

Quest Software World Headquarters

LEGAL Dept
5 Polaris Way
Aliso Viejo, CA 92656
email: legal@quest.com

Refer to our Web site (www.quest.com) for regional and international office information.

Trademarks

Quest, Quest Software, the Quest Software logo, Toad, T.O.A.D., Toad World are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. For a complete list of Quest Software’s trademarks, please see http://www.quest.com/legal/trademarks.aspx. Other trademarks and registered trademarks are property of their respective owners.