Beta Version 6.0.0.299
Beta Release Notes
Wednesday, May 15, 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.
General
Toad now allows to search through the script not only in the Editor window but also in SQL Script page of object's DOE (Database Object Editor) and Script tab in the object's DOV (Database Object Viewer). This feature can be handy when reviewing large automatically created DDL scripts. Press F3 or CTRL+F to invoke a search pane.
Object Explorer
(SQL Server 2012) Toad allows to view databases configured for AlwaysOn support. Right-click a database in the Object Explorer, select Options | Extra Columns | Synchronization State or/and Availability Role.
Generate SQL submenu was reorganized. Not when you right click an object and select Generate SQL you are offered to select a type of script to be generated (Create, Alter, Execute, etc.) first followed by To Editor / To Clipboard / To File options.
Object Management
WITH NOCHECK / CHECK syntax is available for the foreign keys and check constraints both in the DOE (Database Object Editor) and scripting. You can navigate to the Constraints page in the Table DOE and set a foreign key to "Trusted". Trusted property is also shown for foreign keys in View Details | Constraints tab for Tables.
When generating execution script for the stored procedures to the Editor, SET @<parametername> = statement is added for each declared parameter. This is handy when you have a lot of parameters declared and need to set them all manually. Just input parameter values without having to type SET statement every time.
When renaming a database you can select whether to keep backup and restore information or not. To omit it set Delete backup and restore information to True in the Rename Database DOE.
Connection Manager
Toad provides possibility to import connections from Central Management Server. Now to add CMS connections to the Connection Manager pane you click Import Connections in the Connection Manager toolbar, select Central Management Server as import origin and specify connection from the list. Select Connections and Groups page of the Import Wizard displays a list of available connections, including CMS. You can either import the entire CMS Connections group or single connection.
Security
Toad provides more security options when creating users in Contained databases (SQL Server 2012 only).
Service Broker
Service Broker has been completely redesigned and now can be configured for MS SQL Server 2005, 2008, 2008 R2, 2012. Service Broker allows to set up communication between databases on the same SQL Server instance or between SQL Server instances. Take advantage of secure, reliable messaging with Service Broker in Toad. Invoke Service Broker with Tools | Administer | Service Broker, select a database from the list and click Configure to enable Service Broker.
In the Endpoints tab you can either configure an endpoint for the current SQL Server instance or configure both source and target endpoints using the Transport Security Wizard.
To create Service Broker objects (e.g. message types, queues, notifications, etc.) select a corresponding tab in the lower part of the Service Broker window.
Storage Management has been significantly improved to become more user-friendly and easy-to-use. Select Tools | Administer | Storage Management to invoke it. In the Drives tab you can review information on free disk space and database parameters (size, total writes, total reads, etc). Click on the drive icon to see the list of databases located there. To move a database to another drive just drag it to drive's icon, specify new location on disk drive and follow the instruction in the pane below.
Editor
GO N syntax is supported. Add it to the end of your script to execute it N times.
Script generation has changed - fully qualified database names are now removed from tables, views, procedures and functions. This allows you to run scripts across multiple databases without having to adjust object names for each database. For example, if you have a production and test databases with identical structure and object names you can deploy the same script for both of them with just USE [Database name] statement.
(SQL Server 2012) Values now can be concatenated using CONCAT (value1, value2,..., valueN) syntax.
Note: Review Microsoft documentation for more information on converting data types.
Script Results
Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
You can add XML declaration when saving XML data to file with a right-click in the Result Sets tab.
Data Grid, Result Sets
Toad allows to view multi-line text as one-line separated by spaces so that you can see all information contained in the grid right in front of you. Right-click a data grid and select Show | Multi-line text as one-line. When this option is cleared, to view multi-line text you have to hover a mouse over a data grid cell or expand it.
| Multi-Line as One-line | Example |
|---|---|
|
Selected |
|
|
Cleared |
|
Data Compare
Schema Compare
Toad allows to run Schema Compare against multiple targets. Specify Source and Target Databases page of the wizard was adjusted to allow source and target objects' selection within the same pane. Click Add to start selecting objects for comparison (snapshots or databases).
Browse through the list of connections and snapshots and check the objects you want to include in comparison. You can also assign colors and aliases for selected objects. Assigning aliases and colors is handy as helps easily distinguish targets.
After specifying objects for comparison, the first one is automatically set as source. Click Set as source next to any object to make it source.
When reviewing multi-target comparison results, the columns at the right of the Objects pane display comparison status per target (source only, target only, different, etc.). The circle sign 
indicates that the object exists neither on source nor on selected target (while it is "target only" for another). The Targets pane gives you a tip what databases are compared and how they are ordered as columns in the Objects pane.
To review object scripts in the Script pane select an object in the Objects pane and click on required target column (selected target column is highlighted). The Properties tab also provides information per selected source and target pair.
Variables
This release of Toad for SQL Server includes many new enhancements to Automation variables. Automation variables are now more flexible and easier to use. Toad for SQL Server has expanded the number of places you can use variables in an Automation script.
You can now use a colon (:) or a forward slash (/) in date/time formats used in Automation variables (except when the variable appears in a file name).
In the Import Wizard and Export Wizard activities, you can now use a variable in the Import/Export template file name.
Loop Dataset Activity
You can use the following format to filter data from the dataset variable when referencing it:
<dataset variable name>.<filter parameter>
Example: Loop_data_1_SQL.region_id, where region_id is the column name
Loop Connections Activity - NEW!
This release includes a new Automation activity called the Loop Connections activity. You can use this activity to loop through multiple connections, executing one or more activities against each connection in the list.
Copy File and Delete File Activities
You can now use standard wildcard characters in the file name to help you select one or more files to copy or delete. Previously, you could use the only the asterisk (*) in the file name to select multiple files to copy or delete.
[pic of Delete File Collection editor]
You can now use a variable in the file name to select one or more files to copy or delete.
[pic of Copy]
Schema Compare
Schema Compare is now available as automation activity. Select it from the list of Database Activities.
Data Compare Activity
Data Compare activity was moved to the Database Activities.
When adding Data Compare activity to Automation, you can either select a comparison project prepared in advance (and alter it if necessary) or run new data comparison wizard.
Automation button was added to the Data Compare toolbar. After clicking this button you will be prompted to save your comparison project. Automation pane is invoked automatically and lists your project in Data compare project field.
Automation Guided Tour
You can send a SQL statement to the Automation Guided Tour from the Editor or the Query Builder by clicking the Send SQL to Automation button in the toolbar.
In addition, the last page of the Import Wizard allows you to send your import template to the Automation Guided Tour.
After completing the wizard, your new script opens in an Automation window where you can further customize and enhance the script, if necessary.
General Enhancements
This release also includes several general enhancements to Automation activities.
Important!
Toad includes significant enhancements to Automation that affect attributes in the actual automation script. If you open an automation script from a previous version, a message informs you that the script will be upgraded so it will work in the current version of Toad.
Caution: If you upgrade this script, it will no longer be compatible with previous versions of Toad. However, a backup copy of your script will be saved in the Automation\bak folder in the Application Data Directory under Help | About.
Open script and look for validation errors icon [pic].
Expressions used in Automation
Some expressions might break in this release of Toad for SQL Server. For example, if you used a variable in an expression, you must now surround the variable name with the hash (#) symbol.
The following is a list of issues addressed and enhancements implemented in this beta release.
|
Feature |
Resolved Issue |
Defect ID |
|---|---|---|
| Code Completion | The columns with ROWVERSION/TIMESTAMP data type is no longer included in the INSERT INTO (...) SELECT (...) code snippet. |
ST98595 Reported by DarrenM |
| Data Grid | "Use locale-independent format" option now works for DateTime, Number data types. | ST106316 |
| Fixed issue with not being able to clear data filter. |
ST106318 Reported by Sergio Bertolotti |
|
| Fixed issue "Applying a column filter on a Bit data type generates exception". | ST104886 | |
| Fixed issue "Unable to cancel pending update in case of locked table". | ST104287 | |
| Diff Viewer | Various fixes and updates (including fixing misaligned comparison, case sensitive comparison, scrolling synchronization, etc.). |
ST92437 ST101899 Reported by HF ST101900 ST101901 Reported by Butter |
| Filtering | Fixed various issues with filtering (filtering by owner, multi column filtering). |
ST106616 Reported by Ercan Yuzbasioglu ST103340 |
| Job Management | Fixed issue with incorrectly displaying 31 month jobs in Calendar. |
ST104499 Reported by Sergio Bertolotti |
| Object Details (DOV) | Alter Table: Fixed issue with Columns and Data tabs not being refreshed after adding a primary key. |
ST106415 Reported by JFischer_484 |
| Object Editor (DOE) | Alter Table: Changes can be applied to more than one constraint. | ST104230 |
|
Fixed issue "Incorrect script is generated when editing permissions for not master database. USE MASTER statement is generated instead of USE <current database>". |
ST104122 | |
| Windows Server 2000: Fixed issue with not being able to DROP LOGIN. |
ST108190 Reported by Damien BIT |
|
| Object Explorer | Fixed issue "Unable to Drop Synonyms from the Object Explorer". | ST105807 |
| Fixed issue "Row Count extra column doesn't disappear after being unchecked". |
ST106615 Reported by Ercan Yuzbasioglu |
|
| Schema Compare & Sync |
Fixed issue "System.Exception appears when trying to print Schema Compare report provided that Schema Compare was opened via Tools | Compare | Schema Compare or File | Open File or File | Recent Files". |
ST104282 |
| Fixed issue "Toad fails to open user's Schema Compare snapshot". |
ST106632 Reported by Ercan Yuzbasioglu |
|
| Additional logging is implemented. | ST107318 | |
| Fixed issue "System.ApplicationException appears when comparing databases with keys". | ST107093 | |
| Fixed issue "Schema Compare fails on Windows Server 2012 with particular permissions settings". |
ST108300 Reported by Arlie |
|
| Schema Reports | Fixed issue "Schema Report: System.NullReferenceException occurs when generating the report". |
ST106314 Reported by Sergio Bertolotti |
| Script Generation | Fixed issue "Generate Insert Statement contains timestamp columns". |
ST107529 Reported by Darren Myher |
| Fixed issue "Extended alter script generates for about 3-5 minutes on complex table". |
ST100308 Reported by HF |
|
| Restore database syntax was improved. |
ST105237 Reported by HF |
|
| Script Results | GO with count statement is supported in Toad. |
ST96560 Reported by noonand |
| Service Broker | Service Broker now supports SQL Server 2008. | ST60874 |
| Service Broker now supports SQL Server 2012. |
ST100053 |
|
| SQL Editor | Fixed issue with incorrect formatting for identity columns. |
ST103025 Reported by HF |
| Fixed issue with recognizing labels as incorrect syntax. |
ST105344 Reported by HF |
|
| Improved format style for joined tables. | ST100761 | |
| Version Control | Fixed issue with not being able to commit functions with inline table-valued syntax. | ST107889 |
| Fixed issue "New active task appears when Commit window opens even if commit is not initialized". |
ST104845 Reported by mcarillon |
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 6.0 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 6.0 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 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 |
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 |
|
In the following environment, Microsoft .Net Framework 4 installed on Windows 7 or Windows Server 2008 R2, some users may experience that Toad unexpectedly closes while running certain Automation scripts. After the application closes, a "Toad has stopped working" message displays. You may also encounter this issue if you close Toad immediately after the successful execution of certain Automation scripts. Workaround: Install Microsoft Framework .Net 4.5. |
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 be able to utilize majority of Toad functionality please grant VIEW DEFINITION on the SQL Azure 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.
You can join the Toad for SQL Server beta discussion group by sending an email to: toadssbeta@questmail.info
Submit your ideas to improve Toad and vote or comment on other people's ideas. http://toadss.ideascale.com
|
|
|
|
|
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.
© 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,