Main Navigation Section

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.

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 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.

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.

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.