Quest Toad Data Modeler Release Notes

Quest® Toad™ Data Modeler
version 2.25 f

Release Notes

OCTOBER 2006

Contents

Welcome to Toad™ Data Modeler
What's New
Resolved Issues and Enhancements
Known Issues
System Requirements
Global Operations
Getting Started
For More Information

Welcome to Toad™ Data Modeler

General information about the 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 over 20 different databases, design and generate SQL, create HTML or RTF reports, and generate data flow diagrams, in addition to versioning of database designs and creation of to-do lists.

The freeware version doesn't include all features and allows you to save a model with less than 25 entities .

What's New

Updates to Toad™ Data Modeler Version 2.25

SQL preview available on tab DDL of the Entity and Relationship dialogs
New reverse engineering dialog
Image maps available in generated HTML reports
HTML Report preview
GUI improvements
Bug Fixes and improvements in support for Oracle, PostgreSQL and Sybase ASE

Resolved Issues and Enhancements
The following is a list of issues addressed and enhancements implemented in this release of Toad™ Data Modeler:

Improvements in Reverse engineering dialog

CR# i0013

New dialog for Reverse engineering.

Automatic saving of settings under new alias name

Aliases displayed in grid

Cleared white spaces in generated SQL code

CR# i0014

White spaces removed from the generated SQL code.

HTML reports

CR# i0015	Image maps available in the ER diagram.
CR# i0016	Style preview available on the Generate HTML report dialog

SQL/DDL preview

CR# i0017

New DDL tab added to Entity and Relationship dialogs. Note: During generation of DDL only the checkboxes and text boxes on tabs How to generate and Advanced are taken into consideration. The checkboxes on tab What to generate are always selected. If a user selects a checkbox on the How to generate tab or the Advanced tab, he has to click Default so as his selection of checkboxes was taken into consideration during generation of DDL.

GUI changes

CR# i0018	Description tab renamed to Comments, HTML and RTF report templates modified.
CR# i0019	Environment Setup dialog modified and renamed to Options Conversion between databases settings added to the Options dialog Patterns for Text Objects removed (accessible from Text Objects only) Enabled databases added to the Options dialog Possibility to select default target database.
CR# i0020	Model properties dialog modified Possibility to add a link to external documents like *.doc files.
CR# i0021	Changes in toolbars: Model properties icon moved next to Options Self-relationship icon added .
CR# i0022	Dictionary menu item renamed to User Defined Types
CR# i0023	Link to Toad Data Modeler Yahoo! group added to the Help menu, under About.
CR# i0024	Tooltips added to all toolbar buttons.
CR# i0025	Improved or modified right click options in accordance with consistency requirements (dialogs Reverse Engineering, Script Generating, Visible relationships in Submodel and Submodel).
CR# i0026	Mnemonics improved, icons from buttons removed.
CR# i0027	Right click options added to left sided OverView tree.
CR# i0028	Right click item Background color, which is available when a user selects multiple entities was renamed to Color.
CR# i0029	Resizeable Submodel dialog.

Oracle 10g and Oracle 9i improvements and bug fixes

CR# i0040	Reverse engineering script modified. Tables from the selected schema will be loaded after the schema is selected. By default (and as the first) the schema, which the connected person owns, is selected (also Oracle 8)
CR# i0041	The Reverse engineering process for Oracle will be concluded by a message: "Process completed" in the Log window. (also Oracle 8)
CR# i0042	The Load all accessible objects "ALL_" checkbox removed from the RE dialog. (also Oracle 8)
CR# i0043	The Load procedures, functions, views and packages on selected schemas only checkbox renamed to Load procedures, functions, views and packages from the schemas with selected tables only.
CR# i0044	RE bug fix: The bug that appeared during RE where WRAPPED used data types were loaded (during loading of columns) has been fixed.
CR# i0045	When Owner was not filled out, the constraints that should have been generated after indexes were not written out. (They were written out in their places before generating indexes.)
CR# i0046	The list of tables for RE is loaded much faster after you click Connect (Some properties on tables are loaded after the Execute is clicked now.)
CR# i0047	Default data type set to Varchar2(30). Previously, default data type was Varchar2(20) for Oracle 10g and Oracle 9i and Char for Oracle 8.

PostgreSQL 8.1 and 8.0 improvements and bug fixes

CR# i0030	Unique constraints generated via Alter table.
CR# i0031	Modified handling of Serial and BigSerial datatypes and sequences. New checkbox "Load primal serial data types" checkbox added to Reverse engineering dialog.
CR# i0032	New checkbox "Generate Index to Foreign Key" available on the Relationship dialog.
CR# i0033	Improved verification. New check box "Verification of equal foreign key constraint names" added to the Model verification dialog.
CR# i0034	Default name for indexes set to IX_fkconstraintname_childtablename.
CR# i0035	Single quotation mark in comments replaced with double quotation mark, instead of back-slash and single quotation mark.

Improvements in QDesigner import templates (limited functionality)

CR# i0036	Loading of logical names of Tables, Columns, Domains, Alternate keys, Relationships (FK), Users, Roles.
CR# i0037	Loading of comments to: Tables, Columns, Domains, Alternate keys, Relationships (FK), Users, Roles, Indexes
CR# i0038	Loading of cardinality (limited) and mandatory parent settings

Import ERWin 4.1 models (limited functionality)

CR# i0012

Import from ERWin. Supported databases: Oracle 9 and SQL Server 2000

Sybase ASE improvements and bug fixes

CR# i0039

Added support for newer Sybase ASE 15.0 ESD #2, Sybase ASE 12.5.3a and Sybase ASE 12.5.4.
Encryption columns supported, however, Create encryption items are not loaded.

Other bug fixes

CR# i0048

Bug related to selection of Visible relationships in submodel fixed. TDM selects correct items now.

Known Issues

Reverse engineering PostgreSQL database

The Universal RE option should be selected (File menu -> Reverse engineering -> Universal reverse engineering).
The PostgreSQL 8.1/8.0 item should be selected from Execute script combo box.
PostgreSQL - ODBC connection: It is necessary to use appropriate ODBC driver for RE PostgreSQL 8.0 or 8.1 database. The driver that is installed during PostgreSQL 8.0 or 8.1 installation should work properly.
PostgreSQL 8.0 – Native connection: "Error loading library 'libpq.dll'!" - This message appears in case you have not installed library "libpq.dll", which is distributed with the PostgreSQL package. Please find and download this dll from http://www.postgresql.com. Then copy it into c:/windows/system32 folder or into Toad Data Modeler folder, subfolder Bin, Eg. C:/Program Files/Quest Software/Toad Data Modeler/bin.
PostgreSQL 8.1 – Native connection: The following .DLL files have to be installed on your computer: libpq.dll, comerr32.dll and krb5_32.dll. These files are distributed with the PostgreSQL package (standardly at: "C:\Program Files\PostgreSQL\8.1\bin"). Copy the files to the Windows system directory (c:/windows/system32 folder ) OR to the BIN directory of Toad™ Data Modeler (possible path: "C:/Program Files/Quest Software/Toad Data ModelerBin").

HTML reports with Flash navigation items

HTML reports with Flash navigation items don't open particular HTML page in desired frame (page is opened in a new window instead). The issue appears only when Flash Player 9 is installed on user's PC machine. For more information please see Adobe technote at http://www.adobe.com/go/50c1cf38

SQL/DDL preview

Identity information in DB2 needn't be displayed properly (provided that you use the Identity columns text object)
DDL is not supported for MySQL 5/4.1/4.0. On the DDL tab of entities and relationships, "Not supported" is written out.

Import from ERWin and QDesigner

This feature has limited functionality. Details can be found in the on-line help, section Features | Import.

System Requirements

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

Processor
Memory	min 256 MB
Hard Disk Space	min 30 MB
Monitor
Operating System	Microsoft Windows 98/Me/NT+IE4/2000/XP
Additional Software
Browser	MSIE 4.0 or higher

Global Operations

Globalization statement

Toad Data Modeler can only support one language and character set at a time. (Single Language At a Time - SLAAT)
Toad Data Modeler doesn't support multibyte characters, the product works with ANSI and outputs are also encoded in ANSI.
Font settings for the application, editors and diagrams can be changed to any international font with a support for national characters on the Fonts tab of the Environment Setup dialog.
For HTML and RTF reports it's necessary to change Code page and Character set settings in the internal Templates Editor.
Strings encoded and stored in UTF in your existing database system must be converted into ANSI during the reverse engineering. See your database client (and ADO/ODBC) settings for details or read your database client native documentation.

Getting Started

Contents of the Release Package

The Toad™ Data Modeler distribution CD -OR- package contains the following products:

Quest Toad™ Data Modeler version 2.25
Product Documentation, including:

Online Help, which provides context-sensitive help when working with the application.

Note: You can display the online help by selecting the Index item in the Help menu.

Installation Procedure

1. Download Toad™ Data Modeler from the following site: http://www.quest.com/Toad_Data_Modeler/

2. Start the installation process and follow the instructions of the Setup Wizard.

3. Use your Authorization key to unlock the software.

If you have previously installed Toad Data Modeler 2.25 you do not have to un-install it. Your TDM installation is going to be automatically updated by running Toad Data Modeler 2.25 setup.

For More Information

Contacting Quest Software:

Phone:	949.754.8000 (United States and Canada)
Email	info@quest.com
Mail:	Quest Software, Inc. World Headquarters 5 Polaris Way Aliso Viejo, CA 92656 USA
Web site:	http://www.quest.com/

Please refer to our Web site for regional and international office information.

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/

From SupportLink, you can do the following:

Quickly find thousands of solutions (Knowledgebase articles/documents).
Download patches and upgrades.
Seek help from a Support engineer.
Log and update your case, and check its status.

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

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.