Toad Data Modeler
Thursday, April 05, 2012
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.
Review the following sections for new features and updates in this release:
Changes in comparison with Sybase ASE 15.5
Entities support compression, LOB compression + Level
Columns—compressed + level, Computed Columns => NotCompressed
Changes in comparison with Microsoft SQL Server 2008
Changes in comparison with PostgreSQL 9.0
Relationship—Not Valid checkbox option when adding a constraint of a foreign key.
BOM header was made optional for UTF-8 exports. To set, go to Settings | Options | Model |Physical Model, tab General, Encoding Used for SQL Scripts.
New Select options were added to the former Pointer tool on the toolbar. See Select Objects topic in Help | Model | Model Objects for more information.
There is only one common button for aligning functions on the toolbar and when clicked, the Align Palette pops up. It lists all align functions available. See Align Objects topic in Help | Model | Model Objects for more information.
Toolbar and Menu Styles are available via window context menu and in Settings | Options | General.
See topic How to call TDM from other Applications in Help | Automation for samples.
Dictionaries tool is available from the Tools menu and allows you to add and translate new terms in your current dictionary from other dictionaries, import web-based dictionaries and export dictionaries to the web (in CSV file format).
New settings option for Automatic FK Mapping was added in Settings | Options | Model | Physical Model, tab General. See topic FK Mapping in Help | Model | Physical Data Model | Entity Relationship Diagram | Keys | Foreign Keys for more information.
Faster work with Attributes:
New option to set Margin was added in the Export to Graphic File dialog.
New options have been added to the relationship Right Angled style context menu Change Line to Right Angled.
Object Format dialog- Force Right Angled Line, which enables right angled mode for a single line, and Lock Points in Right Angled Mode checkboxes were added on the Line tab.
Workspase Format dialog and Options | Physical Model options dialog—Right Angled Lines and Lock Points in Right Angled Mode checkboxes added.
New buttons Save and Delete have been added in the Connections dialog, tab Connections. If you have made any changes to the selected alias, you can save them. Or you can delete the selected Alias.
New Native Connection (UniDAC component) has been added. It brings the following enhancements:
Formerly, Refactoring Utility worked on the basis of mare searching for and replacing of words. It has been thoroughly reworked and now it becomes a sophisticated tool working on the basis of syntactic analysis and comparison, which will eliminate unwanted replacements and errors.
Added functionality to allow reordering attributes/columns via scripting.
See samples for scripting in Help | Scripting and Customization | Sample Scripts and Scripting Tips:
If already signed up as a modeling community member, you can register you ideas and suggestions for new features and improvements in Toad Data Modeler in the Idea Pond at http://toaddatamodeler.ideascale.com/. Vote for the ideas to bubble them up and increase the chances of having them implemented earlier.
The following is a list of issues addressed and enhancements implemented in this release.
|Feature||Resolved Issue||CR ID|
|SQLite 3.7||Support for SQLite 3.7||96668|
|Sybase IQ 15.2||Support for Sybase IQ 15.2||96665|
|GUI||In editable forms, Ctrl+A shortcut enabled to select all text.||95961|
|Sybase ASE 15.7||Support for Sybase ASE 15.7||95614|
|PostgreSQL||Add plpgsql language definition as an offered option in the Language combo box in Function Properties dialog for PostgreSQL databases.||95582|
|Microsoft SQL Server 2012||Support for Microsoft SQL Server 2012||94509|
|Object Viewer||Searching based on object type not working.||94032|
|SQL Script||BOM header made optional for UTF-8 exports.||93783|
|Application Variables||Button <%> for Application Variables removed from the objects where it isn’t interpreted.||93777|
|Scripting||Model.RefreshWorkspace(WS.Id); not working—Fixed||93297|
|PostgreSQL||Support for PostgreSQL 9.1.||92719|
|Alter Script||Access Violation thrown when generating Alter Script for Microsoft SQL Server 2008.||92706|
|Access Violation error thrown because of an issue connected with FK Attribute mapping.||92649|
|LER||Error thrown when calling Model Properties from the Application View. - Fixed||91729|
|HTML Report||On Chrome browser, errors appear. - Fixed||91702|
|PDF Report||PDF/RTF report shows key1, key2, etc. on primary keys even if it does not have primary keys. The keys were empty and showed only in the entities table. - Fixed||91313|
|General||Error when saving a model in a network directory. - Fixed||91208|
|Version Manager||Error “List index out of bounds (2).” thrown when closing revision of a model via Close Other Tabs option of a model context menu. - Fixed||90355|
|Reverse Engineering||Issue with reverse engineering a model from Oracle 11g database, which includes an index over a virtual column. Error "ORA-54018: A virtual column exists for this expression.”. - Fixed||89687|
|Some users not loaded during RE from Microsoft SQL Server 2008. – Fixed for all Microsoft SQL Server versions and Microsoft SQL Azure.||89615|
|Conversion||PER to PER conversion between Microsoft SQL Server 2008 and DB2 9.7- IncludeCols attribute from Index does not make it to the new model. - Fixed||89392|
|Microsoft SQL||Identity in domain- unnecessary properties not migrated from PK to FK— Microsoft SQL Server 2000/2005/2008 and Microsoft SQL Azure||88396|
|General||Check for Update message box- bad spelling and wrong display of version numbers fixed.||87963|
|Connections||Save button added in the Connections menu to enable updating settings of Aliases.||86723|
|Export to Graphic File||Option to set Margins in the exported file.||86638|
|Model Explorer||Sort attributes/objects by creation order (Nature Order), not only alphabetically.||86600|
|Scripting||Model can’t be saved when having been changed via scripting (Save button not active) until any other change is made. - Fixed||85924|
|Reordering columns via scripting added.||84631|
|Not working Model.RefreshWorkspace(WS.Id); in scripting.||55305|
|Workspace||On Windows 7, issues with resizing workspace and objects remaining out of workspace.||73834|
|PostgreSQL||RE- Comments contents not interpreted correctly when UTF8 is used – Fixed.||69068|
|Teradata||Support for Teradata 13||52113|
|Views||Visualization of attributes in the diagram.||51377|
|Empty Primary Keys||Empty PKs can be deleted from models where they were automatically generated for tables. For new models PKs are not generated automatically.||46898|
There aren't any known issues at the time of this release.
|Feature||Known Issue||Defect ID|
Though SQLite database is case insensitive, Reverse Engineering in Toad Data Modeler is case sensitive. This leads to a problem that e.g. when a column name is "ATR" and an index is defined with column name "Atr", the names do not get paired and an error message is thrown.
|If some object name includes UTF characters, then the object does not get loaded during Reverse Engineering.||98200|
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.2.6) in a lower version of Toad Data Modeler (e.g. v. 3.6.6).
Before installing Toad Data Modeler, ensure your system meets the following minimum hardware and software requirements:
|Memory||Minimum 512 MB , 4 GB recommended|
|Hard Disk Space||Minimum 200 MB, 400 MB recommended|
Microsoft Windows XP (32-bit or 64-bit, Service Pack 2)
Microsoft Windows Vista (32-bit or 64-bit)
Microsoft Windows Server 2003 (32-bit or 64-bit, Service Pack 2)
Microsoft Windows Server 2008 (32-bit or 64-bit)
Microsoft Windows Server 2008 R2 (64-bit)
Microsoft Windows 7 (32-bit or 64-bit)
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
Microsoft Access 2000, 2002, 2003, 2007, 2010
Microsoft SQL Azure
Microsoft SQL Server 2000, 2005, 2008, 2012
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, 9.1
Sybase ASE 12.5, 15, 15.5, 15.7
Sybase IQ 15.2
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
Any PDF reader (for viewing the Installation Guide)
Review the following information about using Toad Data Modeler in virtual environments:
Toad Data Modeler has been tested for Citrix support on Windows XP using the XenApps 5.0 Server.
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.
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 tested ones.
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 Toad Data Modeler Community.
Chinese (Simplified and Traditional), Czech, Hebrew, Hindi, Punjabi, Russian, Spanish, Brazilian Portuguese and Italian
The Toad Data Modeler release package contains the following products:
Refer to Installation Guide for 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.
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.
Quest Software, Inc.
5 Polaris Way
Aliso Viejo, CA 92656
See our web site for regional and international office information.
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.
© 2012 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
5 Polaris Way
Aliso Viejo, CA 92656
Refer to our Web site (www.quest.com) for regional and international office information.
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.