Compare and synchronize—Lets you compare and synchronize servers, schemas, and data to track change or easily migrate a database between production test and development environments
Group execute—Executes scripts and code snippets against multiple servers and instances
Log Reader management—Rolls back transactions in the transaction log without the need to restore from a backup
SQL optimization—Enables 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
T-SQL editing—Toad 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
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
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
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
Free high-quality performance health checks—Benchmarks against average performance across the community
Project management—Lets you save and reuse powerful features for object management, SQL, and T-SQL coding
Security management—Builds and executes security-related scripts against multiple servers to create, manage, and even replicate security for all users
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 (Learn More)
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 (Learn More)