Intuitive Interface – Offers the same look and feel as Toad for Oracle.
Quick Installation – Provides fast and easy setup capabilities, so you can start taking advantage of Toad’s powerful functionality in just minutes.
Support for Microsoft Windows Excel 2010 – Enables you to work directly with Excel.
Script Generation – Delivers flexible, complete, fast, and accurate script generation.
Large Data Set Support – Makes it simple for you to work with data sets of any size.
Task Scheduling – Runs tasks automatically according to parameters you set.
Quest SQL Optimizer – Validates SQL to maximize performance. Purchase this as a stand-alone product or within Toad for SQL Server Xpert Edition.
Advanced Search Capabilities – Locates the data you need in record time through the Schema Compare and Generate DDL functions.
Support for SQL Azure – Connects to SQL Azure. You must have read access to the master database.
Group Execute – Executes SQL scripts across multiple instances.
Compare and Synchronize – Compares and synchronizes data, schemas, and servers in a few clicks.
Transaction Log Reader – Recovers data stored in transaction log files, rolls back operations, and reconstructs transactions.
Xpert Tuning – Resolves SQL performance issues automatically. Identify, tune, and benchmark problematic SQL, no matter where it resides in your environment. Investigate indexing strategies through automated index generation.
Recall SQL Scripts – Saves every SQL statement executed against the database automatically. Allows you to quickly locate statements for review or save them for long-term use.
Version Control – Integrates with popular version-control vendors, including Visual Source Safe, Subversion, and CVS.
SQL Performance Optimization – Ensures optimal performance by automatically identifying SQL Server performance tuning opportunities, optimizing, and testing SQL prior to deployment.
Query Builder – Lets you quickly drag and drop tables to create queries.
Report Writer – Documents database objects and report on schemas. Includes support for pivot grids and a chart designer.
Database Administration – Simplifies SQL Server administration tasks. Create, alter, and manage database objects, SQL code, users, logins, and security across multiple servers.
CodeCompletion – Automates the coding process and provides SQL Server tuning suggestions for rapid completion of T-SQL commands.
Difference Viewer – Enables you to identify discrepancies between files, data, and objects, then edit duplicate data. Export data to Excel with linked queries and add notes to database objects.
Grid Customization – Offers customizable data grid styles.
Visual Data Modeling – Shows tables, dependencies, and database relationships in your SQL Server environment in a data modeling view.