Toad for SQL Server

Discover the highest level of code quality, performance and reliability – while saving time and streamlining development tasks.

Enhance your SQL Server database operations by improving productivity and performance

With more SQL Server databases to manage than ever, it’s hard to perform all your administration tasks effectively while staying on top of database performance. But what if you had an easier way to do both?

With Toad® for SQL Server, you get extensive automation, intuitive workflows and built-in expertise to maximize productivity and reduce risk. This comprehensive toolset complements Microsoft tools by solving key SQL Server challenges, so you can proactively manage many databases. You’ll easily resolve issues, manage change and promote the highest levels of code quality, performance and scalability with Toad® for SQL Server.

Download Free Trial

Features
Tour
Specifications
Resources
Support & Services

Features

Compare and sync

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

Group Execute

Enables a number of scripts to be executed against different servers at the same time.

Log Reader

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

Job Manager

Helps you manage the load on your database to improve efficiency.

SQL Optimizer

Conduct application performance tuning with automated query rewrites and optimization.

Performance testing

Perform industry standard benchmarks or database workload capture and replay to ensure the future scalability of your critical database.

Data modeling

Provides physical and logical data modelling capabilities and enables reverse engineering from other data sources.

Automation

Automate repetitive tasks, including data and schema comparisons.

Tour

Toad for SQL Server - Editor

Toad is a powerful toolset for creating and debugging your T-SQL.

Toad for SQL Server - Schema compare

Schema compare compares and synchronizes one-to-many schemas, giving you more flexibility in schema comparisons.

Toad for SQL Server - Data compare

Comparing and synchronizing your data is a straight-forward and easy process with Toad’s data compare tool.

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.

Toad – Performance monitor

The performance monitor provides information on the processes running on the SQL Server instance.

Toad – Index fragmentation

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

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.

Toad for SQL Server - Automation

Project management is easy with automation.

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.

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.

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.

Download Free Trial

Specifications

Client requirements

CPU: 600MHz minimum, 1GHz recommended

Memory: 512MB of RAM minimum, 1GB recommended

Hard disk space: 104MB

Operating system

Windows Server® 2003
Windows Vista® (32-Bit or 64-Bit)
Windows Server® 2008 (32-Bit or 64-Bit)
Windows Server® 2008 R2(64-Bit)
Windows Server® 2012

Windows® 7 (32-Bit or 64-Bit)
Windows® 8 (32-Bit or 64-Bit)
Windows® 8.1 (32-Bit or 64-Bit)
Windows® 10

.NET Framework: Net 4.0 - Windows Vista (SP1 or earlier), Windows Server 2003
.Net 4.5 - Windows Vista SP2, Windows 7, Windows 8, Windows Server 2008 (SP2 or earlier), Windows Server 2008 R2, Windows Server 2012

Additional requirements: Microsoft® 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) 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
SQL Server 2014 Enterprise and SQL Server 2014 Express

Cloud database services: Azure® SQL Database v12

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

Resources

Datasheet

Toad for SQL Server

Reduce time spent on SQL Server application development and database administration.

On Demand Webcast

The Cross Platform DBA: Managing Oracle and SQL Server

In this webcast, you will learn some of the trends in today’s database industry that drive heterogeneous database adoption.

White Paper

How to Use SQL Server’s Extended Events and Notifications to Proactively Resolve Performance Issues

SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to react to events that have already occurred. As DBAs, we need to monito

Technical Brief

Solving the SQL Tuning Problem - Secrets of the SQL Optimizer

This technical brief provides a detailed technical view into the SQL Optimizer and how it provides a solution for improving SQL statement performance that an internal database management system's SQL optimizer cannot provide. We also see how the SQL Optim

Technical Brief