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.

Contact Us for more information

logos

LeadThem Consulting
20418 SE Hwy 212
Damascus, OR 97089