|

Toad for SQL Server

Final week!
Save up to 35% on PCs designed to power your business. Special pricing ends September 22, at 7 a.m. CT.  Save Now › 

Run faster, more reliable databases.

Easily manage more SQL Server databases and automate repetitive tasks.


 

 

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.
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.
  • Client requirements

    Platform
    600 MHz

    Memory
    512 MB

    Hard disk space
    104 MB

    Operating system
    Microsoft® Windows Server® 2003
    Microsoft Windows XP (32-Bit or 64-Bit)
    Microsoft Windows Vista® (32-Bit or 64-Bit)
    Microsoft Windows Server 2008 (32-Bit or 64-Bit)
    Microsoft Windows 7 (32-Bit or 64-Bit)
    Microsoft Windows 8 (32-Bit or 64-Bit)
    Microsoft Windows Server 2008 R2(64-Bit only)

    .NET Framework

    4.0

    Required browser
    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)
    SQL Server 2008
    SQL Server 2008 R2
    SQL Server 2012 ("including Express" applies to SS 2005-2012)
    Cloud database services SQL Azure®

    Note:  Download free trial to see the full list of system requirements
DocumentsDocuments
Download printable materials to gain insight on how this product can help you simplify IT challenges.
  
EventsEvents
Peruse webcasts and in-person activities near you to explore the technology behind this product.
  
CommunitiesCommunity
Get the most from this product as you join your peers and Dell experts to access tools and learn best practices.
Dell Software | Contact Us

Contact a Dell Expert

Get help with all your business needs.

Learn More
Dell Software | Support

Software Product Support

Single location for all your product needs.

Learn More
close
 
 
CS05