Toad DBA Suite for SQL Server » Developer Team - The Best Site for Developers | Developer's Paradise

Toad DBA Suite for SQL Server

Toad DBA Suite for SQL Server
Toad DBA Suite for SQL Server | 124 Mb

Toad Software is a database management toolset from Quest that database developers, database administrators and data analysts use to manage both relational and non-relational databases using SQL. Take a proactive approach to database management. Re-focus your teams on more strategic initiatives, and move your business forward in today’s data-driven economy.

Toad solutions enable you to maximize your investment in data technology by empowering data professionals to automate processes, minimize risks and cut project delivery timelines by nearly half. Lower the total cost of ownership for new applications by reducing the impact of inefficient code on productivity, future development cycles, performance and availability.

See why millions of users trust Toad for their most critical systems and data environments. It’s time to gain the competitive edge.

Work smarter and meet the demands of today’s database environments. Toad simplifies workflows, automates frequent or repetitive processes, and minimizes risks associated with changes– whether you’re a database developer, administrator or analyst.

Unified SQL Server database management tool to save time and improve performance

Run faster, more reliable databases by doing more work in less time. As a single toolset, Toad for SQL Server database management tool maximizes productivity through extensive automation, intuitive workflows and built-in expertise. Plus, it complements Microsoft tools by solving key SQL Server challenges, so you can proactively manage many databases. Easily resolve issues, manage change and promote the highest levels of code quality, performance and maintainability.


Query builder
Enable DBAs and analysts to easily export to their favorite tools. Access key data quickly (including built-in report and pivot functionality) for in-place analysis and single-click export to an Excel instance.

Compare and sync
Easily identify differences by comparing and syncing servers, schemas and data.

Log reader
Roll back transactions in the transaction log without restoring from a backup.

SQL optimizer
Conduct application performance tuning with automated query rewrites and optimization.

Automate repetitive processes, including data and schema comparisons.

SQL script recall
Save time by eliminating the need to retype commonly used SQL and T-SQL statements. Track any SQL executed during your Toad session.

Group execute
Process scripts and code snippets against multiple servers and instances.

Security management
Create, manage and even replicate security for all users by building and executing security-related scripts against multiple servers.

Report generation and documentation
Develop customized reports for administration and development, and export those reports in flexible formats, including .xls, XML, .doc and .pdf.

Object search
Rapidly locate code to quickly assess the impact of renaming or code changes by searching for text in database objects (such as column names and SQL code).

Project management
Save and reuse powerful features for object management, SQL and T-SQL coding.

T-SQL editing
Reduce the T-SQL learning curve, introduce consistency and help deliver high-quality code. Simplify SQL coding with advanced code complete, code snippets and SQL recall.

Consistent toolset
Minimize the learning curve across multiple platforms. Enjoy a similar look and feel while receiving deep functional expertise for the nuances of each platform.

New Features in 6.8
Version Control supports Team Foundation Server 2013, Team Foundation Server 2015 and VSTS
Different versions of Team Foundation Server in the Provider dropdown in Version Control setup dialog is now combined into one
TFS 2017 can be connected successfully, however, it is not fully tested with this release of Toad
Version Control supports Git
Git is added to the provider list for configuring Version Control
Plugin supports SQL Server Management Studio 2016 and SQL Server Management Studio 2017
Plugin can be installed in SSMS 2016 and SSMS 2017 however there are issues on the following conditions:

Known issue #1: if Toad for SQL Server is installed into Program Files (x86) folder, the plugin cannot be installed successfully.
Solution #1:
1)     select a destination folder outside of Program Files (x86) to install Toad

2)     if Toad plugin menus are still not visible in SSMS, please refer to known issue #2

 Known issue #2: if UAC is enabled for the folder where SQL Server Manager Studio is installed, the plugin cannot be installed successfully.
 Solution #2:
1)     find InstallPlugins.bat from [ToadInstallDir]\Plugins\SqlServer\SSMS\

2)     right click the bat file and select “Run as administrator”

3)     verify Quest.ToadSSMSExtenion.pkgdef is created in %ProgramFiles(x86)%\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Extensions\ToadExteion\

4)     start SSMS

Plugin still supports SSMS 2012 and SSMS 2014, however there are following known issues:

Known issue #3: plugin is not installed correctly for SSMS 2014.
Solution #3:
1)     find Quest.ToadSSMSAddin.dll.config from %ProgramData%\Microsoft\MSEnvShared\AddIns

2)     if the folder doesn’t exit, refer to known issue #4

3)     edit Quest.ToadSSMSAddin.dll.config using Notepad or other text editor

4)     find Dell.ToadSSMSAddinCore in the file and replace it with Quest.ToadSSMSAddinCore

5)     save the file

6)     start SSMS 2014

Known issue #4: plugin cannot be loaded in SSMS 2012 and SSMS 2014 when the user doesn’t enough permission on %ProgramData%\Microsoft\MSEnvShared\AddIns.
Solution #4:
1)    find Quest.ToadSSMSAddin.AddIn and Quest.ToadSSMSAddin2012.AddIn in “C:\Documents and Settings\All Users\Application Data\Microsoft\MSEnvShared\AddIns”

2)    edit Quest.ToadSSMSAddin.AddIn and Quest.ToadSSMSAddin2012.AddIn using Notepad or other text editor

3)    find <Assembly>C:\ProgramData\Application Data\Microsoft\MSEnvShared\AddIns\Quest.ToadSSMSAddin.dll</Assembly> or <Assembly>C:\ProgramData\Application Data\Microsoft\MSEnvShared\AddIns\Quest.ToadSSMSAddin2012.dll</Assembly> in the file content

4)    change it to <Assembly>C:\Documents and Settings\All Users\Application Data\Microsoft\MSEnvShared\AddIns\Quest.ToadSSMSAddin.dll</Assembly> or <Assembly>C:\Documents and Settings\All Users\Application Data \Microsoft\MSEnvShared\AddIns\Quest.ToadSSMSAddin2012.dll</Assembly>

5)    save the file, continue on 6) to 9) for SSMS 2014, skip to 10) for SSMS 2012

6)    find Quest.ToadSSMSAddin.dll.config from C:\Documents and Settings\All Users\Application Data\Microsoft\MSEnvShared\AddIns

7)    edit Quest.ToadSSMSAddin.dll.config using Notepad or other text editor

8)    find Dell.ToadSSMSAddinCore in the file and replace it with Quest.ToadSSMSAddinCore

9)    save the file

10)  start SSMS

Log Reader and Job Manager support SQL Server 2016
New edition naming reflects license edition
About box and splash screen now show “Part of Toad for SQL Server xxx Edition 2017”. (xxx is the license edition such as Professional, Xpert, Developer and DBA)

Only for V.I.P
Warning! You are not allowed to view this text.
Users of Guests are not allowed to comment this publication.