What's New in Toad for Oracle 14.x? (4323217)

What's New in Toad for Oracle 14.x

Version 14.0 (Major)

Subscription Licensing

Note: Applies to Toad for Oracle Subscription with online licensing.

• Toad for Oracle Subscription maps licenses to your Quest.com account which are managed via a new, self-service licensing portal. Sign in with your Quest.com account to begin using Toad immediately. New users are automatically issued a 30-day trial during which you are free to explore all of Toad's features.

• Subscription Licensing

Note: Applies to Toad for Oracle Subscription with online licensing.

Toad for Oracle Subscription was introduced in version 14.0, but limited to Base product functionality. We are pleased to announce that the following editions are now supported:

• Toad for Oracle Professional

• Toad for Oracle Professional + DB Admin module

• Stability and Security Improvements

Much emphasis was placed on improving application stability and security. Well over 100 defects identified by customers, internal testing, and by data collected from the Toad Improvement Program were resolved.

The Toad Improvement Program collects anonymous usage data to help the Toad for Oracle team identify usage patterns and prioritize new development including, but not limited to, organizing the UI to make the features you rely on more accessible. The Toad Improvement Program also collects data on unhandled exceptions so that we can identify and resolve defects. We'd like to thank all who participate in Toad's ongoing success by enabling Toad Improvement Program data collection. To enable Toad Improvement Program data collection, select "Yes" to the participation opt-in in Options (View | Options | Online).

• Import Table Data

Import can now resume after connection loss.

• Explain Plan

Treeview mode now supports Adaptive Plans.

• Automation Designer

New action added for single column export.

• Workspaces

Improvements to loading saved workspaces:

• All connections are restored upfront so that any user interaction, i.e. entering passwords, is handled efficiently.

• If one or more connections fails to restore the workspace will continue restoring other connections and their windows.

• Certified Version Engine

As part of ongoing efforts to ensure the continued performance and security of our products, we are certifying our product releases up to specific Oracle database and Windows releases. When there is a new Toad for Oracle release available, we will notify our users to upgrade to the latest release.

Version 14.2 (Minor)

• Automation Designer

• A new menu item has been added, "Change connections...," which allows for changing the connection associated with one or more selected actions.
• The Execute Script action has a new option to enable/disable substitution variables. This is useful when executing a script having an ampersand in its path.

• Code Snippets

• The Code Snippets datafile is now in JSON format which is less likely to suffer from corruption in the event Toad shuts down abnormally.

• Compare Data

• Settings can be saved to file and loaded for future comparisons.
• A new option has been added to compare LOBs by their length which is faster, but not 100% accurate. See the "Compare LOBs by length only" option in the Features section of the Compare Data options tab.

• Compare Multiple Tables

• Table name filter now supports a comma separated list of table names in addition to traditional filters using wildcard (%).
• Memory consumption improvements when comparing LOBs.
• A new option has been added to compare LOBs by their length which is faster, but not 100% accurate. See the "Compare LOBs by length only" option on the Compare Multiple Table options tab.

• Compare Schemas

• Exclusion file now supports excluding items only in Source or Target schemas and excluding items with differences.

• Connections

• A new option has been added to automatically attempt a reconnect one time if a session disconnect is detected. If the reconnect was successful then Toad will seamlessly continue the operation in most cases. There are a few instances where Toad will not be able to complete the operation. Those include working with datasets that are already fetched into a grid and debugging. See the "Auto-reconnect if timeout or disconnect occurs" option in View | Toad Options | Oracle | Transactions.
• Improved error message when there are no Oracle clients installed that eliminates unnecessary UI elements and provides a link to download the client.

• Make/Strip Code

• The Make/Strip Code datafile is now in JSON format which is less likely to suffer from corruption in the event Toad shuts down abnormally.

• Schema Browser

• Shortcuts associated with common Schema Browser actions can be configured. See View | Toad Options | Toolbars/Menus | Shortcuts

• Sensitive Data Protection

• Table comments are now included in sensitive data searches.

• Subscription Licensing

• Improved error message when an invalid license key is entered.
• Notification is presented when there are new editions available.

• Toolbars

• Toolbar layouts are now migrated from prior releases. A status bar notification will appear alerting you to the possibility that your migrated toolbars may be excluding menu item changes and new features. From the notification you can reset your toolbars to get the latest toolbar definition.

• Workspaces

• Schema Browser Quick Filters and the active right side detail tab are now saved.
• Editor windows and their contents are now restored even if the connection bound to them could not be restored.