Toad™ for SQL Server® Functional Matrix
Free Professional Xpert Development
Essential Functionality Edition Edition Edition Suite
Browse and navigate through database objects
Create and manipulate database objects through
graphical interfaces
Edit: snippets, predictive typing, syntax highlighting
Unicode support
Support for the latest database platform version: SQL
Server 2012
Development Functionality
Advanced code completion and SQL formatting
Manipulate and explore SQL with Script Map, that
provides fast, structured and clear representation of
your script
Execute scripts against multiple servers and instances.
Query Builder
Compare code differences, database objects and files
ER Diagram with HTML Reporting
Integrated Debugger
Convert embedded SQL to other programming
languages (e.x. Delphi, C, C++, Java, Perl and VB)
Connect to, develop, and administer SQL Azure
databases with the same Toad functionality as
provided for on-premise SQL Server
Team Collaboration
Manage project assets, share common standards and
templates
Source Control Integration with over 10 version
control systems
View RSS and twitter feeds, including Toad
community postings for greater collaboration
Code Analysis and SQL Optimization
Visual SQL explain plan
Trace user sessions and visually display SQL Trace
output
Identify problematic SQL directly from database
objects, files and source code
Automate SQL rewrites to locate the most-efficient
SQL alternative (internal to Editor and full external
optimizer)
Optimize multiple SQL statements in batch, in
context, with the source code, and provide the
optimized code
Dell Software August 2013 1
Recommend the indexes and analyze impact on
database environment through index simulation
Test SQL and T-SQL for scalability under simulated
user loads to validate performance under production
conditions
Database Administration Free Professional Xpert Development
Edition Edition Edition Suite
Browse multiple managed databases, perform tasks
and drill down to the object level
Browse, navigate and manage database-specific
objects like tables, views and roles
Quickly close existing database objects
Group objects across a server instance
Conduct server-side filtering on a per-database-
object-type basis, including named filters
Redo or undo transactions stored in log files by
reading online transaction logs, detached transaction
log files or log file backups for reconstructing
transactions
Execute one or more scripts against one or more
databases
Connect to, develop, and administer SQL Azure
databases with the same Toad functionality as
provided for on-premise SQL Server
Schema, Data and Change Management
Compare data between two databases, identify
differences and run or generate a script to
synchronize.
Compare schema between one source and many
databases, identify differences and run or generate a
script to synchronize. Compare one source to
multiple targets in one step.
Compare server setup and configuration between two
databases, identify differences and run or generate a
script to synchronize.
Automate (and schedule) data and schema compare
with Toad Automation.
Import/export data utilities
Import/export data from data grid into/from Excel and
other files
Advanced, highly-productive data grids offering
simple column selectivity and grouping
Display table data representing Parent-Child
dependencies (Master Detail Browser)
Reverse engineer objects DDL, including roles and
permissions to recreate objects in a different
DB/schema
Replay database workload to simulate production
Dell Software August 2013 2
load levels in a test environment prior to deployment
or implementation of database or platform changes
Simulate database workloads using out-of-the-box
industry-standard benchmarks such as TPC-C and
TPC-E
Reporting Free Professional Xpert Development
Edition Edition Edition Suite
Generate customizable database reports such as
schema and data reports
Automate report generation and distribution
Generate reports on potentially problematic SQL and
optimization results
Performance Diagnostics and Optimization
Browse sessions, trace and manage database
processes and locks
Integration with Project Lucy which delivers daily
performance health report
Detect and defragment inefficient indexes
Monitor and snapshot key performance metrics
Analyze the impact of new indexes and index changes
on the database
Analyze SQL execution plan changes between
different DB environments (e.x. Dev vs. Prod or SQL
Server 2005 vs. 2008)
General
Restrict access to Toad features
Access knowledge and educational content on Toad
World and other resources directly from the search
bar
Context-sensitive knowledge base, including best
practices, worked examples, error messages and
much more
Distribute configurations and settings to a group of
users
Reorganize and summarize data to create meaningful
reports with pivot grids
Identify discrepancies between files, data and objects,
then edit duplicate data using Difference Viewer
Use Automation to schedule a single script to run
reports and queries, save results in Excel
spreadsheets, and distribute results to the business
community via email.
Reduce manual effort and enhance productivity by
recording and playing back keyboard commands
using Macros
Dell Software August 2013 3
