Toad for SQL Server 7.0 - Release Notes

Toad for SQL Server 7.0

Toad for SQL Server 7.0.x

Release Notes

Thursday, July 25, 2019

Contents

About Toad for SQL Server

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 7.0.7 is a patch release with new enhancements and resolved issues.

New Features

New Features

In Toad for SQL Server 7.0 the following new features were implemented:

New Features in 7.0

  • Support for Active Directory authentication when connecting to an Azure SQL database. Client configuration is required, see https:// docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication-configure#configure-your-client-computers
  • Support for extended properties of Azure SQL databases
  • Support for Azure SQL data warehouse
  • Support for comparing multiple servers in the Automation feature

See Resolved Issues for more enhancements and resolved issues in this release of Toad for SQL Server.

Learn More

Get the latest product information, find helpful resources, and join a discussion with the Toad for SQL Server team and other community members. Join the Toad for SQL Server community at Toad World.

System Requirements

System Requirements

Client Requirements

Before installing Toad, ensure that your client system meets the following minimum hardware and software requirements:

Requirement Details

Platform

2 GHz processor (recommended minimum)

Memory

4 GB of RAM minimum, 16 GB recommended

Note: The memory required may vary based on the following:

  • Applications that are running on your system when using Toad
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database

Hard Disk Space

800 MB to install Toad

104 MB to run Toad

Note: The disk space required may vary based on the edition of Toad selected for installation.

Operating System

Windows Server® 2008 R2 SP2

Windows Server® 2012

Windows Server® 2012 R2

Windows Server® 2016

Windows Server® 2019

Windows® 7 SP1 (32-bit or 64-bit)

Windows® 8.1 (32-bit or 64-bit)

Windows® 10, version 1809

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 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.7.1

Additional Requirements

Web Browser

Microsoft® Internet Explorer® 11 or later

Screen

Toad supports screen resolutions up to 3200 x 1800 and display DPI settings up to 150%

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.

http://www.microsoft.com/downloads/details.aspx?FamilyID=200B2FD9-AE1A-4A14-984D-389C36F85647&displaylang=en

Server Requirements

Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:

Requirement Details

Database Server

SQL Server 2012 and SQL Server 2012 Express

SQL Server 2014 Enterprise and SQL Server 2014 Express

SQL Server 2016

SQL Server 2017

Notes: 

  • SQL Server Compact Edition is not supported.
  • Storage Management is not available on SQL Server Express.

Note: To use Access 2016 64-bit to connect to an Access database in Toad, the Microsoft Access Database Engine is required and might not be included in the Access installation. The engine must match the architecture (bitness) of Toad.

Cloud Database Service

SQL Azure and Azure SQL Data Warehouse

Note:  To be able to utilize a majority of Toad functionality, please grant VIEW DEFINITION on the SQL Azure databases you want to work with.

Virtualization Support

Requirement Details
Application Virtualization

When deploying Toad in a virtualization environment, for best results ensure the system accurately reflects the applicable client hardware and software requirements listed in this document.

Toad has been developed using Microsoft guidelines (see Remote Desktop Services programming guidelines) and can be deployed and operated in virtualization environments such as Citrix XenApp, Microsoft App-V, and VirtualBox.

Install Toad on Citrix® Systems

Server Virtualization

Toad has been tested with the following:

  • Oracle VM 3.1 running on Red Hat Enterprise Linux 64-bit with Oracle 11gR2
  • Oracle VM 2.2 running on Windows 2008 32-bit with Oracle 11gR2

User Requirements

User Requirements to Install Toad

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—on the computer.

If a Power User installs Toad, a Restricted User cannot do the following:

  • Associate file extensions.
  • View the Toad shortcut icon on the desktop or the Toad menu options in the Windows Start menu. As a workaround, Restricted Users can create a shortcut to Toad from the install directory and place the shortcut on their desktop.

User Requirements and Restrictions for Running Toad

The following describes the requirements and restrictions for users who launch and run Toad:

  • To create or modify the QuestSoftware.ToadSecurity table to enable Toad Security, the user who maintains this table must have privileges to create, insert, update, and delete it. All other users need only the ability to read the QuestSoftware.ToadSecurity table to use Toad Security features.

Resolved Issues and Enhancements

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release of Toad for SQL Server:

Resolved Issues in 7.0.7

Feature Resolved Issue / Enhancement Defect ID
General Support bundle now generates correctly. QAT-14988
Script Generation Generating INSERT statements now works instantly even for tables with large numbers of rows. TSS-1663/4512804
Pivot Grid Pivot Grid column subtotals can now be formatted. QAT-14608
Default subtotal summary type was changed to SUM for string values in Pivot Grid. QAT-14837
There is an new option to show aggregate total values for row categories that only have one value. The default is to not display totals when there is only one value. QAT-14998
It is now possible to display subtotals for single values. Click Set pivot grid properties on Pivot Grid toolbar to enable. QAT-14998

Resolved Issues in 7.0.6

Feature Resolved Issue / Enhancement Defect ID
Automation An issue when Excel spreadsheet exported during Automation was not displayed is now fixed. QAT-14819/4498499
Compare Object Generating a Schema Snapshot does not save a file in network path. It appears to do so but does not. This has been fixed. TSS-1650
Installation Users should be able to deploy license keys during installation. This was broken in Toad Data Point 5.0 and is now fixed. QAT-14834/

4510329,

4516827,

4516600

Pivot Grid A scroll bar has been added to the row area in Pivot Grid. QAT-14705
Query Builder

Vertical scroll bar is now displayed in Cross-Connection Query Mode of Query Builder.

QAT-14749
Query Builder

A Group By button for aggregated functions has been added to Query Builder.

QAT-14609

 

Resolved Issues in 7.0.5

There were no resolved issues in this version of Toad for SQL Server.

Resolved Issues in 7.0.4

Feature Resolved Issue / Enhancement Defect ID
SQL Editor Users can now select the directory to serialize large results sets. The option is located under Database | Script results QAT-14377

Resolved Issues in 7.0.3

Feature Resolved Issue / Enhancement Defect ID
Automation Usage connection from parent activity has been reworked. A new option From parent has been added which indicates whether the currently used connection should recursively search for parents QAT-13279
Data Compare & Sync 'Conversion Overflows' error when doing a data compare on a Microsoft Dynamics table has been fixed TSS-1628
Data Compare & Sync SQL Server Schema compare now supports FULLTEXT INDEX when table object includes FULLTEXT INDEX type of index TSS-1423

Resolved Issues in 7.0.2

Feature Resolved Issue / Enhancement Defect ID
Automation In an Automation script, if a Data Compare activity included a detail report in an email that used a suffix, the report would not be attached and throw an error. This has been resolved TSS-1633
Automation Error when .xlsm file could not be exported using Automation script has been fixed QAT-14201
Connection Manager SQL Server Connection error now displayed to the user is now formatted correctly TSS-1491
Data Compare & Sync SQL Server Schema compare now supports FULLTEXT INDEX when table objects include FULLTEXT INDEX type of index TSS-1423
Pivot Grid Pivot Grid now allows you to use Aggregated data values in a calculated field QAT-14074
SQL Editor New option in Tools | Options | Editor | Tools | Auto highlight selected word enables auto highlighting of selected words TSS-1606

Resolved Issues in 7.0.1

Feature Resolved Issue / Enhancement Defect ID
Connection Manager Import Connections now supports import/browse connections from SSMS 18.0 TSS-1607
Connection Manager Contained user could not connect and display objects to SQL Azure database. This has been fixed TSS-1483
Data Compare & Sync Error when data cannot be filtered has been fixed QAT-14057
Data Generator Data Generator script was failing due to non US regional settings in Toad for SQL Server TSS-1475
Import Wizard Toad now handles hidden columns within the Import Wizard TDB-3648
Pivot Grid Pivot Grid now supports Top N rows so one can sort and filter for top N values of pivoted data QAT-12434
Query Builder Corrected issue in Query Builder to reverse engineer SQL that contained a UNION and where condition QAT-13812
Query Builder Prior to executing mixed case aliases, the Query Builder would change to upper case causing the execution to fail QAT-13581

Resolved Issues in 7.0

Resolved Issue Defect ID
Quick Export now supports Office 365 Excel. TSS-1309
Corrected a problem where an open transaction was left in the database with the Script tab. TSS-1325
Corrected slow performance issue with Object Explorer. TSS-1469
Corrected a slow performance issue on first query of a database. TSS-1470
Enhanced report that was too long / contained unnecessary information. TSS-1484
Corrected a problem where running multiple statements took too long in Toad for SQL Server 6.8. TSS-1450
Punctuation is an unexpected token in Toad for SQL Server 6.8.1. TSS-1493
Corrected a problem with Data Generator. TSS-1494
Corrected a problem completing a "Security Migration" task. TSS-1507
Corrected a problem with Schema Compare - Named versus a System-Named Constraint. TSS-1525
Corrected a problem with Data Compare - wrong key mapping. TSS-1521
Corrected a problem with Schema Compare - "use statement is not supported to switch between databases". TSS-1534
Corrected a problem with Schema Compare - error with stack trace. TSS-1524
Corrected a problem where Toad for SQL Server crashed when adding a new user from Active Directory. TSS-1526
Corrected a problem where Toad for SQL Server left open transactions on a busy server. TSS-1547
Corrected a problem where selection of backup file in Native or LiteSpeed Backup File failed TSS-1581
Corrected a problem with the shorcut for shared snippets. TSS-1062
Corrected a problem where the code completion sum function was not working so well on the SQL server platform. TSS-1575
Corrected a problem where the catalog view 'federations' is not supported in this version" - SQL Azure DataWarehouse TSS-1548
Corrected a problem where the Snippet Token was not working. TSS-1453
Corrected a problem with the Refresh button on the Perspective page. TSS-935
Corrected a problem where an internally generated query caused an idle blocking situation. TSS-1401
Corrected an error with Insert statement when generating SQL. TSS-1508
Corrected a problem where the contained user could not connect to the SQL Azure database. TSS-1483
自助服务工具
知识库
通知和警报
产品支持
下载软件
技术说明文件
用户论坛
视频教程
联系我们
获得许可 帮助
技术支持
查看全部
相关文档