Toad for SQL Server

loading

Toad for SQL Server - Editor

Toad for SQL Server - Editor

Toad is a powerful toolset for creating and debugging your T-SQL. The editor provides outstanding coding possibilities with code snippets, SQL recall, script map and intelligent code completion, while group execute allows you to execute your scripts against multiple servers and instances.

Toad for SQL Server - Schema compare

Toad for SQL Server - Schema compare

Schema compare compares and synchronizes one-to-many schemas, giving you more flexibility in schema comparisons and the ability to complete your tasks in a single effort. Multi-target schema compare can also run as automation activity.

Toad for SQL Server - Data compare

Toad for SQL Server - Data compare

Comparing and synchronizing your data is a straight-forward and easy process with Toad’s data compare tool. Besides great automatic mapping, it features the ability to manually create “object per object” and even “column per column” mapping and specify comparison keys. This flexibility allows you to compare differently organized objects and ensures high-quality, precise results. The comparison results are easy to navigate through, as searching and filtering are available.

Toad for SQL Server - Job manager

Toad for SQL Server - Job manager

The job manager provides a simple visual display of jobs on multiple SQL Server instances against a calendar view, making it easy to avoid resource contention caused by job conflicts.

Toad for SQL Server - Performance monitor

Toad for SQL Server - Performance monitor

The performance monitor provides information on the processes running on the SQL Server instance, their performance cost, and visualizes gathered information in the charts.

Toad for SQL Server - Index fragmentation

Toad for SQL Server - Index fragmentation

Index fragmentation quickly detects indexes that require defragmentation and reorganizes or rebuilds them.

Toad for SQL Server - Data Diff Viewer

Toad for SQL Server - Data Diff Viewer

The data diff viewer uses data-compare best practices, including “column per column” mapping and the ability to view source and target data grouped by the mapping rule. Data diff viewer also compares temporary data, e.g., two results sets. The text diff viewer provides a convenient way to review differences based on the object definitions.

Toad for SQL Server - Automation

Toad for SQL Server - Automatio

Project management is easy with automation. Represent your workflow step by step and save it as an automation script, schedule execution, and focus on other tasks.

Toad for SQL Server- Version control

Toad for SQL Server- Version control

Toad’s easy-to-use version control ensures versioning of your objects when sharing database projects across your team. Built-in version control can be configured for subversion and Team Foundation Server, making the latest changes available right from Toad’s context menu.

Toad for SQL Server - Log reader

Toad for SQL Server - Log reader

The log reader reconstructs the transaction log, provides the ability to review exact SQL scripts that were executed against the specified database, and lets you roll back potentially harmful ones without having to restore from a backup.

Toad for SQL Server - Object explorer

Toad for SQL Server - Object explorer

Browsing objects with the object explorer is easy and highly customizable; you can create custom filters, and set tabbed, dropdown or treelist views. Open the object details and navigate through to get quick access to object properties and key attributes, data, dependent and referenced objects, DDL scripts and more.

Easily manage more SQL Server databases and automate repetitive tasks

  • Compare and sync server, schema and data to identify differences
  • Execute scripts and T-SQL snippets against multiple servers and instances
  • Identify performance bottlenecks and automate SQL optimization
  • Perform database workload replay and performance benchmark testing
  • Utilize a common toolset from development through production

Overview

Run faster, more reliable databases by doing more work in less time with Toad™ for SQL Server®. This single toolset 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 large numbers of databases. It also makes it easy to manage change, resolve issues quickly and promote the highest levels of code quality, performance and maintainability.

Compare and sync server, schema and data to identify differences

Track change or easily migrate a database between production, test and development environments by comparing and synchronizing servers, schemas, and data.

Execute scripts and T-SQL snippets against multiple servers and instances

Save time by automating the execution of scripts and T-SQL snippets against multiple servers and instances simultaneously.

Identify performance bottlenecks and automate SQL optimization

Conduct performance tuning with automated SQL scan, optimization, index optimization, and benchmarking; no other tool offers the level of performance tuning that is available in Toad™ Xpert.

Perform database workload replay and performance benchmark testing

Conduct benchmark testing, scalability testing, as well as database workload replay in a test or development environment to simulate production scenarios and determine system throughput or identify database breaking points.

Utilize a common toolset from development through production

Use a single, integrated and comprehensive toolset that includes both development and production functions.

Features

Compare and synch
Lets you compare and sync servers, schemas, and data, and enables easy identification of differences.
Group execute
Processes scripts and code snippets against multiple servers and instances.
Log reader
Rolls back transactions in the transaction log without the need to restore from a backup.
SQL script recall
Tracks any SQL executed during your Toad session and eliminates the need to retype commonly used SQL and T-SQL statements, saving time.
SQL Server job manager
Provides a simple visual display of all running jobs on multiple databases against a calendar backdrop, making it easy to avoid resource contention caused by job conflicts.
Security management
Builds and executes security-related scripts against multiple servers to create, manage, and even replicate security for all users.
Report generation and documentation
Lets you create customized reports for administration and development and export those reports in flexible formats including .xls, XML, .doc and .pdf.
SQL optimization
Enables performance tuning with automated SQL scan, optimization, and benchmarking; no other tool offers the level of performance tuning that is available in Toad Xpert.
Object search
Allows you to search for text in database objects, e.g., column names and SQL code, and helps you rapidly locate code to quickly assess the impact of renaming or code changes.
Project Lucy integration
Provides free high-quality performance health checks benchmarked against average performance across the community.
Project management
Lets you save and reuse powerful features for object management, SQL, and T-SQL coding.
T-SQL editing
Makes SQL coding easy with advanced code complete, code snippets, and SQL recall; this reduces the T-SQL learning curve, introduces consistency, and helps deliver high-quality code.
Query builder
Helps you access key data quickly; includes built-in report and pivot functionality, which allows for in-place analysis and single-click export to an Excel instance, so DBAs and analysts can easily export to their favorite tools.
Complete suite
Provides a comprehensive, end-to-end toolset, from development through production administration, as well as integration with Spotlight for performance diagnostics.
Consistent toolset across database platforms
Minimizes the learning curve across multiple platforms with a similar look and feel while providing deep functional expertise for the nuances of each platform.

Specifications

Client requirements

CPU
  • 600 MHz
Memory
  • 512 MB
Hard disk space
  • 104 MB
Operating system
  • Windows Server® 2003
  • Windows® XP (32-Bit or 64-Bit)
  • Windows Vista® (32-Bit or 64-Bit)
  • Windows Server 2008 (32-Bit or 64-Bit)
  • Windows 7 (32-Bit or 64-Bit)
  • Windows 8 (32-Bit or 64-Bit)
  • Windows Server 2008 R2(64-Bit only)
.NET Framework4.0
Additional requirementsMicrosoft® Internet Explorer® 6.0 or later
Database server
  • Limited support of SQL Server 2000 (Service Pack 3 or later)
  • SQL Server® 2005 (Service Pack 2 or later)
  • SQL Server 2008
  • SQL Server 2008 R2
  • SQL Server 2012 ("including Express" applies to SS 2005-2012)
Cloud database servicesSQL Azure®

Detailed requirements

Download free trial to see the full list of system requirements.

What's New

Version 6.0

  • SQL Server Management Studio plugins
  • Automation of schema and data compare and synch
  • Ability to compare result sets from queries, table data, and more
  • Ability to import connections directly from Central Management Server
  • Storage management enhancements
  • Significant rework to the service broker workflow
  • Query development updates