Toad for SQL Server
Discover the highest level of code quality, performance and reliability – while saving time and streamlining development tasks.
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.
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
Specifications
- 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
American Electric Power: Energy company enhances database performance
American Electric Power improves database performance for end users with Toad.
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.
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
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
The Real World of the Database Administrator: How DBAs Like You Are Managing Their Data.
See how data growth and new technologies are affecting the DBA ― read the eye-opening study today.
Miami-Dade: County enhances critical services for citizens
Miami-Dade County streamlines database administration and development with Toad.
- More Resources
- Communities
- Events & Demos
- Research Docs
- Customer Stories
Take the next step
Related Products
Spotlight on SQL Server Enterprise
Diagnose SQL Server performance issues quickly and accurately for a healthy database infrastructure
Toad Data Modeler
Create high-quality data models and easily deploy accurate changes to data structures
Benchmark Factory for Databases
Save time troubleshooting production issues, and quickly implement new applications.
Toad Data Point
Simplify data access, preparation and provisioning.
SharePlex
Achieve ZeroIMPACT database replication with the affordable golden alternative.
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.