Toad Data Modeler Changelog

What's new in Toad Data Modeler 5.3.4.13

• NEW FEATURES:
• Support for Microsoft SQL Server 2014:
• New option to define Table and User Data Types as Memory Optimized
• New option to select Durability in Memory Optimized tables
• New options available for Indexes and Keys of Memory Optimized tables - Hash Index, Bucket Count and Statistics Incremental
• New Type of Stored Procedure - Natively Compiled Stored Procedure
• Added new tabs Selective XML and Selective Secondary XML to Index Properties
• New Index types available in Index | General | Type of Index - Columnstore, Selective XML, Secondary Selective XML
• Support for DB2 10.5 (LUW):
• New options to organize entities:
• Organize by Row using Insert Time
• Organize by Row using Dimensions
• Organize by Column
• New option to set parameters OCTETS/CODEUNITS16/CODEUNITS32 for the following Data Types:
• CHAR, VARCHAR, CLOB allow OCTETS/CODEUNITS32
• GRAPHIC, VARGRAPHIC, DBCLOB allow CODEUNITS16/CODEUNITS32
• New option to Include/Exclude Null Keys in Indexes
• XML Index Specifications allow parameter OCTETS/CODEUNITS32
• New option to set parameters of Data Types:
• CHAR, VARCHAR, CLOB allow OCTETS/CODEUNITS32
• GRAPHIC, VARGRAPHIC, DBCLOB allow CODEUNITS16/CODEUNITS32
• Support fro Microsoft Windows 8.1 PRO (64-bit)
• New Model Actions window - contains the most used Model Features and allows you to save time by using Action Definitions. Click on Window Menu | Model Actions or Model | Manage Model Actions to display it
• New Filter Bar located in:
• Model Explorer
• Category Properties
• Object Groups
• New Synchronization Options Toolbar - Contains all Synchronization Actions that were previously located in File and Model Menus
• Improved Compare Tree Dialog in Model Actions - Added several new buttons for easier item management
• New option - Indexes to Foreign Key Generation
• Change Script/Alter Script options concerning use of Temporary Tables are now available also in Generate Change Script wizard | DDL Code Generation step
• New Quick Search Icon added to the Window Toolbar
• ENHANCEMENTS:
• General enhancements:
• To prevent inserting templates into SQL code immediately after selecting them from combobox in Stored Procedure Properties, users now have to select a template and click the Insert Template icon.
• New option in Comparison Settings - Remove Trailing Whitespace. Ignores trailing whitespace characters during Model Comparison. Enabled by default.
• Quick Search icon added to the Window Toolbar.
• Database-specific enhancements:
• Custom terminator can now be defined for DB2, MySQL, SQL Server and Microsoft SQL Azure during reverse engineering a DDL script. This is done in Connecting dialog while setting up a new Connection.
• Default terminator in DB2 (LUW and zOS) changed from "/" to ";" both in Reverse Engineering and DDL Script Import.
• PostgreSQL - system schemes and roles are now by default marked as not generated.
• Microsoft SQL Server- Change Script generator considerably improved and sped up
• RESOLVED ISSUES:
• General issues:
• Resizing Label / Label Ellipse by dragging the corner points is almost impossible. Fixed.
• The Label Ellipse sometimes moves randomly from its previous position. Fixed.
• Generating PDF and RTF reports - unchecking "Generate All Model Objects" checkbox (A workspace needs to be selected in Select Workspace combobox) in Options dialog in Report Wizard resulted in Microsoft Jscript Runtime error during execution. Fixed
• Error during moving selection with Snap to Grid option enabled. Fixed. 496
• Recalculate size function issues when using other than default zoom. Fixed.
• Constraint for default value generated twice in alter script. Fixed.
• Attribute Unique Data Type lost after synchronization. Fixed.
• Moving objects in workspace could cause Model Test errors. Fixed.
• Live Reverse Engineering drag-and-drop to Gallery was possible even when it shouldn't be. This caused Application Violation. Fixed.
• Model Test would evaluate a situation with a view containing two attributes of the same entity as an error. Fixed.
• Database-specific issues:
• Oracle - entities using allowed public synonyms are flagged as invalid by Model Verification. Fixed.
• Oracle - Parse Error when IFILE is used in TNSNAMES.ORA. Fixed. 564
• PostgreSQL 9.1 and 9.2 - An entity can be selected as both temporary and unlogged at the same time even though these two options exclude each other. Fixed.
• PostgreSQL - Incorrect order of the roles generation for DDL scripts. Fixed 357
• SQL Server - Errors caused during Alter Script generation by using bad SQL command. Fixed.