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.

Features

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.

Automation
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.6 
Test Data Generator 
Use the Test Data Generator to generate realistic test data to load into your databases. 

To open the test data generator click File | New | Data Generator 

Create a Test Data Generator project. 

Set the scope of the project by setting the Toad for SQL Server connection and database schema. 
In the test data generator window: 
Test data is generated for ticked tables and columns, 
Select a table or column, 
Set the settings for that selected table or column, 
Preview and edit test data, 
Generate test data, 
Further configure and export. 
Query Development 
Background Processes 

The Background Processes pane now identifies the Query Builder or Editor document window (if any) associated with a running process. If you have multiple statements executing simultaneously, this makes it easier to match a running process to its associated document. Click the running process in the Background Processes pane to display the associated document window. 

In addition, for each Query Builder or Editor document with an active background process, an animated progress icon displays in the window's tab. This allows you to quickly see which windows have executing statements. 
Analyze Joins 

Toad now provides a tool to help you analyze and visualize joins in the Query Builder or a Database Diagram. After building a query or a diagram, click the join between two tables in a diagram. Toad profiles the data based on the relationship between the tables and presents the information in a Venn diagram. Click a section of the diagram to view the values represented by that section. 

The Venn diagram also indicates if a join is a Cartesian join. This gives you the opportunity to modify the join before executing the query. 

Sort Columns 

You can now sort columns in a table diagram in the Query Builder. Right-click a table and select Sort. This is useful for finding a column when the table or view has a large number of fields. 

View PDF Files in LOB Viewer 

You can now view PDF files in the LOB viewing pane in the Database Explorer, SQL Editor, or Query Builder. In the Data tab or Result Sets tab, in a LOB column, open the drop-down LOB viewing pane. If the LOB is a .pdf file, it is displayed in the PDF tab. 

Automation 
Throw Error Activity 

Automation includes a new activity that allows you generate an error and add a custom error message to the script execution log. In addition, you can instruct Toad to stop or continue after the error is logged. This can be useful if you want to terminate the script when a condition exists that would not normally cause an error. 

Automation Reports and Container Activities 

In activities that allow you to select files created in previous activities in a script, reports generated in container activities are now visible in the File Collection Editor. 

Only for V.I.P