When setting your Toad's look and feel in Options | Environment | Interface, you can see skin icons in the list.
Version 5.8.1 (Click here for previous versions)
Release Notes
March 20, 2013
With Toad, developers and database administrators can use a familiar, proven tool to manage databases. Toad empowers developers and administrators, of varying skill levels, to rapidly create and execute queries, automate database object management and develop SQL more efficiently.
Toad also provides utilities to compare, extract and search for objects, manage projects, import/export data and administer the database, while increasing your productivity and delivering access to an active user community.
Toad for SQL Server 5.8.1 is maintenance release containing primary fixes and enhancements to the previous 5.8 release.
When setting your Toad's look and feel in Options | Environment | Interface, you can see skin icons in the list.
When expanding a long list of objects in the Object Explorer, ... signs show the process of data fetching.
When checking your database you can set single user or multi-user mode for DBCC CHECKDB.
Unique and primary keys are listed in the Constraints tab in the Tables DOV (Database Object Viewer). Now you can see all information on table constraints right in one plate.
Working with jobs became more convenient. Now you can specify job's name in Schedule Job page in the object's DOE (Database Object Editor) where you schedule it and easily navigate to it in the Object Explorer later.
"Close existing connections" option is available when renaming databases. You can set it to True in the Rename Database dialog.
"Lock escalation" option is now available in the Options page in the Table DOE (Database Object Editor).
Project Lucy is a powerful online service that allows to create performance analytics on your data and its environment. Project Lucy is free of charge and does not require any plug-in installation, you can easily register within the project and upload data and access reports any moment worldwide.
You can set data collection in Toad and upload it to Project Lucy portal, where it is processed. After it you can view detailed reports, charts, statistics and predictive trends as you upload more data. You can also compare your server health metrics with other Project Lucy's members. For more information on Project Lucy see www.projectlucy.com.
To collect data and upload it select Tools | Quest Tools | Project Lucy - Performance Analytics.
Toad allows to schedule data collection and uploading while you can always do it manually any moment.
Important: After the data is uploaded it takes some time for Project Lucy to process it.
After it you can view online reports, click Open link in the Reports column. For your convenience, Project Lucy portal is opened in default browser, but you can also use embedded Toad browser to see the reports. Select Open reports in Toad to do it.
Performance Monitor allows to view real-time charts visualizing your server performance. Performance Monitor can be helpful when you want to see your changes impact on the server. To run it, select Tools | Monitor | Performance Monitor.
Performance Monitor allows to set refresh interval (2 seconds min) that guarantees precision of the metrics, which you can switch on or off at the bottom pane. Performance Monitor provides detailed information on more 15 performance metrics, such as waits, batches, CPU, I/O, etc. When reviewing the performance captures, please pay attention to the following:
To see concrete values in the timeline hover a mouse over a point in the timeline.
To see chart in details move it to the top using arrows and specify the fragment of the chart you want to magnify in the navigation chart at the top. The chart will be scaled to show the selected fragment magnified to the size of the pane. You can move the selection in the navigation chart to see the rest of captured data.
You can compare captures to see dynamics. Click Captures to select captures for comparison. Ones compared you'll be able to see both charts in one plate, the first capture as a continuous line, the second as a dashed line.
To see min, max and average values calculated for the charts navigate to the counters in the pane below. When comparing two captures, the green signs in the Average columns indicate the preferable state of the system.
You can move charts with respect to each other in the timeline. Drag a line to the left or right to align with another capture's chart.
When working with your scripts in the Editor, you can set connection category color as Editor's background color to ensure that you do not execute the script on the wrong server instance. This feature is handy if you have multiple Editor windows opened on several servers and you are constantly switching between them.
To set this option go to Tools | Options | Editor | General and select Apply connection color.
You can make words in the script uppercase or lowercase with a single click. Right-click a text and select UPPER CASE.
Toad allows to save messages to the file. Right-click a message in the Messages tab of the Results pane and select Save as.
This release of Toad for SQL Server includes the new Toad Views feature which allows you to create and save your own personal views. Not only can you reuse SQL, but with Toad Views you can rename your views, organize them into folders, modify existing views, and create new views.
Easily create a Toad View from the Editor or Query Builder windows or from the SQL Recall pane (right-click the SQL statement and select Add to Toad Views).
Use the Toad Views pane to organize, modify, and re-use your views. Or send a view to the currently-open project in the Project Manager.
To use a Toad View, drag it to the Editor or the Query Builder window. The Toad Views you create are also available in code completion in the Editor.
The syntax format for a Toad View is the name of the view surrounded by curly brackets.
For example, SELECT * FROM {{complex queries.alter}}
Diff Viewer
Pasting and editing is allowed in the Text Diff Viewer. So now you can compare data and alter it right in one place.
Version Control has been completely redesigned to become easy-to-use, secure and reliable. Version control can be configured in Toad to work with the following version control systems:
File System Based provider
File System Based provider allows to utilize practically any version control system using the external client tool. In this case Toad version control works with the directories at local HDD while you commit changes to the repository manually. For example, you can store your files within GitHub, Visual Source Safe (VSS), Concurrent Versions System (CVS), etc.
Important: For this release you cannot configure version control on server level.
Version control can be easily configured with Version Control Wizard. To access it, right-click a database in the Object Explorer and select Version Control | Version Control Wizard. Ones, the version control is configured, you can add objects to version control and manage them.
The following objects can be added to Version Control:
TABLE
VIEW
STORED PROCEDURE
FUNCTION
SEQUENCE
UDDT
RULE
DEFAULT
SQL SCRIPT
To add an object to version control right-click it in the Object Explorer and select Version Control | Commit. For version controlled objects you can view history, get latest version, compare revisions (Diff or Diff with latest revision), add to ignore list, etc.
Version controlled objects are marked with signs at the top right corner of the object's icon. To see object's version control status hover a mouse over it.
You can see all objects within current configuration (except for ignored) in the Controlled Objects pane. To access it, right-click any object in the Object Explorer and select Version Control | Show perspective. The objects are grouped by their statuses. In this pane can also view and apply changes, view history, get latest version, etc.
Idea Pond is a site where you can submit your ideas to improve Toad and vote or comment on other people's ideas. Toad's development has always been driven by our customers, and now it is even easier for you to tell us what changes are most important. This site is free for all customers.
Click the following links to view issues addressed and enhancements implemented in the Toad for SQL Server 5.8.x releases, including this latest release 5.8.1:
The following is a list of issues addressed and enhancements implemented in this release.
|
Feature |
Resolved Issue |
Defect ID |
|---|---|---|
| Version Control |
Fixed issue "Toad does not work with Team Explorer 2008 and 2012, only 2010". |
ST105163 |
| Fixed issue with not being able to commit functions that return table. | ST104842 |
The following is a list of issues addressed and enhancements implemented in this release.
|
Feature |
Resolved Issue |
Defect ID |
|---|---|---|
| Code Completion | INSERT INTO (...) SELECT is now based on datatypes and nullability of the fields. |
ST99753 |
| Code Completion does not remove "dbo" from the object's name if you select the item from the filtered Code Completion list. | ST102262 | |
| Fixed issue with incorrect JOIN items order in Code Completion list. | ST102761 | |
| Data Grid | Fixed filtering for BIT and user default data types in Data Grid (Data tab, Script Results, etc.) | ST102711 |
| Import Wizard / Export Wizard | Now when exporting datetime2 column to CSV the fractional seconds are added. | ST101517 |
| Prescan now skips whitespace strings when "empty as null" option is selected. | ST103803 | |
| Master Detail Browser | Fixed issue "System.NullReferenceException occurs when trying to open .xsd file". | ST102094 |
| Migration | Fixed issue with not picking up the filter when migrating it from the previous version of Toad. | ST101802 |
| Object Details (DOV) | Jobs: Fixed issue "Exception appears on reading History tab for the job that was running more than 48 hours". | ST102683 |
| Object Editor (DOE) | Fixed issue with exception raised during extended table ALTER on user specific environment. |
ST101249 ST101250 |
| Fixed issue with double spaces that appeared after copying script to the Editor using clipboard. |
ST98848 |
|
| Fixed issue "When running a script the index created before the INSERT back from the Temp file took over 2 hours". | ST103893 | |
| Alter Table: Fixed issue with missing table permissions in case of Extended Alter after switching between DOE tabs. | ST104049 | |
| Object Explorer | No exception appears after selecting error log entry CTRL + view in the Object Explorer. | ST101803 |
| Fixed issue with incorrect "Not Null" values display for columns. | ST103216 | |
| Reports Designer | Fixed issue with reports generated without data. | ST98707 |
| Schema Compare & Sync | Fixed issue "System.FormatException occurs during Schema Compare launching". | ST102219 |
| Fixed issue with exception raised when loading two snapshots for comparison. | ST102815 | |
| Fixed issue with exception raised if connection included server name with comma but without port number. | ST86591 | |
| Fixed issue with unexpected foreign key drop during synchronization. | ST91175 | |
| Fixed issue "System.ArgumentException occurs when comparing synonyms". | ST102626 | |
| Fixed issue with missing BEGIN / END transaction statements in the Sync script. | ST103338 | |
| Schema Reports | Fixed issue "The column numbers appear prepended to the column names". |
ST82796 |
| Script Generation | The computed columns are not included in the generated INSERT script (Generate SQL | To Editor | Insert Statement). |
ST89108 ST89109 |
| Toad allows to generate ALTER to Column on Complex tables. |
ST100308 |
|
| Fixed issue "System.InvalidCastException occurs when trying to Alter user’s function or get its script". | ST103412 | |
| Session Browser | Fixed issue "System.IndexOutOfRangeException occurs trying to open the Charts tab in Session Browser that lists more than 2048 items". | ST96518 |
| SQL Editor | Fixed issue with incorrect objects names' display after multiple objects were dragged & dropped from the Object Explorer into the Editor. |
ST100440 |
| When script is opened in the Editor, the cursor is now set at the top of the file. |
ST101247 |
|
| Now the Editor does not lose focus ones background task finishes. The Editor has more priority than the background tasks. |
ST100213 |
|
| Fixed issue "Formatter does not react on ALTER INDEX syntax ". |
ST100161 |
|
| After formatting script the scroll bar is placed in the correct position. |
ST77759 |
|
| Fixed issue " Object's schema is recognized incorrectly when two objects with same name were created in different schemas". | ST84019 | |
| Toad now jumps to message tab to notify on conversion failed errors. | ST102596 | |
| Fixed issue with not being able to collapse / expand BEGIN..END block in SQL script. | ST101728 | |
| Version Control | Fixed issue "Impossible to update database objects from Version Control". | ST83321 |
| Fixed issue "TFS 2010: Script is missing when trying to get the latest version of the object". | ST89135 | |
| Subversion: Fixed issue "Impossible to use version control if more than 600-700 objects are added to version control". | ST81054 |
The following is a list of issues known to exist at the time of this release.
|
Feature |
Known Issue |
Defect ID |
|---|---|---|
|
Startup/ Installation |
(Windows Vista on Toad client only) If you initially start Toad when logged in as a standard user and enter a license key, the license key should be saved to: C:\Program Files\Quest Software\Toad for SQL Server 5.8 However, a standard user does not have write privileges in Vista to C:\Program Files so the key is saved to the following directory instead: C:\Users\username\AppData\Local\VirtualStore\Program Files\Quest Software\Toad for SQL Server 5.8 If you later start Toad as an administrator, you are prompted to enter the key again because it is not in the C:\Program Files directory. |
N/A |
| If intending to hibernate the machine with the open connections to the servers that might be unavailable at the next startup, it is recommended to disconnect first due to risk of data loss. | N/A | |
|
When installing Toad using Quest Installer on Windows 7 64-bit, Program Compatibility Assistant may appear with “This program might not have installed correctly” message. Workaround: Select This program installed correctly to continue installation. For more information, see http://windows.microsoft.com/en-PH/windows7/Program-Compatibility-Assistant-frequently-asked-questions |
N/A |
|
| Code Completion | User functions are not displayed in CC list. | ST91806 |
| Code Completion provides limited syntax support of SELECT * INTO clause. | ST87112 | |
| Connection Manager |
Cannot establish Named Pipes connection if "Poll service status in connection list" option is selected. Workaround: Clear "Poll service status in connection list" checkbox on the Tools | Options | Database | General page. |
ST86603 |
| Data | For some queries, attempting to right-click a row and select Row Count results in a message stating that the row count could not be determined. | N/A |
| Debugger | You may encounter some issues when debugging remotely. | ST82044 |
| Editor | Toad may hang after applying Short Format Uppercase Keywords or Short formats to large scripts. |
ST83268 |
| Execution Plan |
You cannot generate an estimated execution plan for queries containing local temporary tables because the execution plan uses a different connection to generate the plan and does not know about the temp table. Workaround:
|
N/A |
| Export Wizard/ One Click Export |
Limitations when exporting fractional seconds:
|
N/A |
|
Avoid using Excel for exporting if your data has numeric values that require a high precision because Excel's precision is limited to 15 digits. If you export numbers with more precision, the values are rounded. If you export boundary numbers (max, min), rounded numbers will exceed the data type limit. |
N/A |
|
| Job Manager | SQL Azure connections currently display in the Job Manager even though the Job Manager is not available for SQL Azure. | ST75721 |
| Log Reader | User information only displays for operations in the sessions that are currently open. Backups do not contain this information because only the SPID information is available to them. |
ST37112 |
| SQL Azure connections currently display in the Read Log wizard even though the Log Reader is not available for SQL Azure. | ST75720 | |
| Object Editor (DOE) |
Incorrect script is generated when editing permissions for not master database. USE MASTER statement is generated instead of USE <current database>. Workaround: Open script in the Editor and manually change MASTER to the proper database. |
ST104122 |
| Object Explorer/ Database Explorer |
Table and Index Partitioning:
|
ST59194 ST68131 |
|
FDCC: User cannot start/stop SQL Agent running Toad with Regular or Admin User account on the client side in some limited environments. Workaround: Start the SQL Agent on the server side. |
ST91618 | |
| Query Builder | Incorrect script is generated for queries containing aliases with more than one word. | ST90493 |
The following is a list of third party issues known to exist at the time of this release.
| Feature | Known Issue | Defect ID |
|---|---|---|
| Automation |
If you are running Windows XP with Service Pack 2 in strong security mode, Windows blocks you from opening zip files sent by Automation if they were created using the Windows Compression wizard. This is a security feature in Windows. Workaround:
|
N/A |
|
Excel |
If an Excel file is open in Toad, you cannot open the same file in a separate Excel instance. To review this and other limitations when using Excel in the Web Browser, see "Considerations When Using the WebBrowser Control" at: http://support.microsoft.com/kb/304662. |
ST42486 |
|
Export Wizard/ |
To export to an Office 2003 or 2007 Excel instance, the Office Primary Interop Assemblies (PIAs) must be installed. You can install the PIAs from one of the following locations: 2003 PIAs: 2007 PIAs: |
N/A |
| Import Wizard | Importing large data sets from Excel (approximately 650,000 rows) is not recommended because of the amount of time it may take. This issue occurs because the Excel import component maintains the output in memory until the import completes. This can cause performance issues depending on the available system resources. | CR#219754 |
Before installing Toad, ensure that your client system meets the following minimum hardware and software requirements:
|
Platform |
|
|
Memory |
512 MB of RAM minimum, 1 GB recommended Note: The memory required may vary based on the following:
|
|
Hard Disk Space |
Note: The disk space required may vary based on the edition of Toad selected for installation. |
|
Operating System |
Windows Server 2003 Windows XP Professional (32-bit or 64-bit) Windows Vista (32-bit or 64-bit) Windows Server 2008 (32-bit or 64-bit) Windows Server 2008 R2 (64-bit) Windows 7 (32-bit or 64-bit) Important: Toad uses the Microsoft Distributed Transaction Coordinator (DTC) when opening a SQL file to get Full-Text Search status, but DTC is disabled by default on Windows Vista, Windows Server 2008 and Windows 7. If you are using either operating system, ensure that Network DTC access is enabled on the Toad client. See http://technet.microsoft.com/en-us/library/cc753510(WS.10).aspx for more information about enabling DTC access. |
| .NET Framework |
Microsoft .NET Framework 4.0 Note: The .NET Framework Client Profile is not supported. |
|
Additional Requirements |
Web Browser Microsoft Internet Explorer 6.0 or later Copy/Move Database Wizard The SQL Server Backward Compatibility package is required to use the Copy/Move Database wizard. Log Reader The Log Reader requires version 8.0 DLL files in the Microsoft Visual C++ 2005 SP1 Redistributable Package. If these files do not exist on the client, you will need to install them to use some functionality in the Log Reader. |
Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:
|
Database Server |
Limited support of SQL Server 2000 (Service Pack 3 or later) Note: The following features are not available:
SQL Server 2005 (Service Pack 2 or later) and SQL Server 2005 Express SQL Server 2008 and SQL Server 2008 Express SQL Server 2008 R2 and SQL Server 2008 R2 Express SQL Server 2012 and SQL Server 2012 Express Note: SQL Server Compact Edition is not supported.
|
| Cloud Database Service |
SQL Azure Note: To connect to SQL Azure, you must have read access to the master database and VIEW DEFINITION grant on the databases you want to work with. |
| Application Virtualization |
Limited testing has been performed for Citrix XenApp 5.0 support on Windows Server 2003. Limited testing has been performed for Citrix support on Windows Server 2003 Enterprise Server (Service Pack 2) using the MetaFrame Presentation Server 5.0 and Citrix Presentation Server Clients 10.2. |
| Desktop Virtualization (VDI) |
Toad has been tested with Quest vWorkspace 7.6 running on Windows Server 2008 R2 64-bit. |
|
Note: Toad may work in virtualization environments other than the ones in which it was tested. |
|
Only Windows Administrators and Power Users can install Toad.
If an Administrator installs Toad, the Administrator can share the Toad shortcut icon on the desktop and menu items with any user—a Power User, Restricted User, Vista standard user—on the computer.
If a Power User installs Toad, a Restricted User cannot do the following:
The following describes the requirements and restrictions for users who launch and run Toad:
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. It supports simultaneous operation with multilingual data. 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.
This release has the following known capabilities or limitations: No known limitations.
The Toad release package contains the following products:
See "Toad for SQL Server Installation Guide" for more information.
|
|
|
|
|
Quest Software, Inc. World Headquarters 5 Polaris Way Aliso Viejo, CA 92656 USA |
|
Web site |
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 our Support Portal at www.quest.com/support.
From our Support Portal, 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: www.quest.com/support.
Get the latest product information, find helpful resources, and join a discussion with the Toad for SQL Server Quest team and other community members. Join the Toad community a http://toadforsqlserver.com/index.jspa.
© 2013 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,