Toad for SQL Server
Group Execute
Toad for SQL Server provides the ability to execute SQL scripts across multiple SQL server instances streamlining administration and development requirements for implementing database changes in a whole sale manner.
Compare and Synchronize
Compare and synchronize data, schemas and servers in Toad for SQL Server's compare and synch tool in a few simple clicks. This allows SQL Server DBA's and developers to you to work within maintenance windows in the face of growing datasets, easing the pain of meeting SLAs and reducing potential for failure.
Transaction Log Reader
Toad for SQL Server allows you to recover data stored in transaction log files, rolling back operations and reconstructing transactions.
Xpert Tuning
Completely automate the process of resolving SQL performance issues. Xpert tuning will identify, tune and benchmark problematic SQL in your SQL Server environment, regardless of where your SQL resides. Xpert tuning also provides the ability to investigate indexing strategies through automated index generation.
Recall SQL Scripts
Toad for SQL Server automatically saves every SQL statement executed against the database environment. These statements can be searched and recalled allowing users to quickly locate statements for review and can also be saved for long-term use.
Version Control
- Toad for SQL Server provides integration with many popular version control vendors including: Visual Source Safe, Subversion and CVS.
SQL Performance Optimization
Optimal SQL performance is ensured through an automated process of identifying, optimizing and testing SQL statements so that the best performing SQL is deployed in the environment.
Query Builder
Toad for SQL Server facilitates the process of coding SQL by letting you quickly drag and drop tables to create queries, from simple to complex.
Reporting
Report Writer in Toad for SQL Server allows you to quickly build a report from the console, facilitating documentation of database objects with the schema reporting. It also includes support for pivot grids, and a chart designer.
Database Administration
Toad for SQL Server simplifies database administration tasks for creating, altering and managing database objects, SQL code, users, logins, and security across multiple servers.
Intellisense
Automate the coding process with intellisense by completing database code activity in the smart' SQL Editor window.
Difference viewer
Difference Viewer helps you to identify discrepancies between files, data and objects, then edit duplicate data; you can also export data to Excel with linked queries as well as add your own notes to database objects.
Grid Customization
Customize the data grid styles visible in the toolset by applying skins to the views quickly modifiable in the Configuration wizard.
Visual Data Modeling
Visualize tables, dependencies and database relationships in your SQL Server environment in a data modeling view.