For the best web experience, please use IE11+, Chrome, Firefox, or Safari

Toad for SQL Server

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.
Millions of data professionals swear by Toad for SQL Server 01:29

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 for SQL Server - Schema compare
Toad for SQL Server - Data compare
Toad for SQL Server - Job manager
Toad – Performance monitor
Toad – Index fragmentation
Toad for SQL Server - Data Diff Viewer
Toad for SQL Server - Automation
Toad for SQL Server- Version control
Toad for SQL Server - Log reader
Toad for SQL Server - Object explorer
Toad for SQL Server - Editor

Toad for SQL Server - Editor

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

Specifications

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

Platform

2 GHz processor (recommended minimum)

Memory

8 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® 2022

Windows Server® 2012

Windows Server® 2012 R2

Windows Server® 2016

Windows Server® 2019

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

Windows® 10

Windows® 11

Deprecated Version of Windows

Toad for SQL customer support will not be available for the following operating systems as Microsoft has stopped providing support for these platforms.

  • Microsoft Windows 8 (64-bit)
  • Microsoft Windows Server 2008 R2 (64-bit)

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

Database Server

SQL Server 2022

SQL Server 2012 and SQL Server 2012 Express

SQL Server 2014 Enterprise and SQL Server 2014 Express

SQL Server 2016

SQL Server 2017

SQL Server 2019

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.

Deprecated Version of Database Server

Toad for SQL customer support will not be available for the following Database Server as Microsoft has stopped providing support for these platforms.

  • SQL Server 6.0
  • SQL Server 6.5
  • SQL Server 7.0
  • SQL Server 2000
  • SQL Server 2005
  • SQL Server 2008
  • SQL Server 2008 R2
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.

Resources

Support & Services

Product Support

Self-service tools will help you to install, configure and troubleshoot your product.

Support Offerings

Find the right level of support to accommodate the unique needs of your organization.