Toad for SQL Server 2.0

Toad for SQL Server 2.0 is yet another extremely powerful tool for database managers. It actually allows you to effortlessly switch between multiple connections at a time and display detailed information for each object selected. The advanced data grid allows data entry or deletion, as well as the ability to filter, sort, or group the data to your specifications.

Performing multiple server administration from a single interface is fast, accurate, and easy by accessing our security migrations dialogue box, or from our DBA module which features a compare and synchronize tool for database schemas, servers, and data. These changes can be implemented across multiple databases immediately, or saved to a script and executed in our powerful SQL Editor interface. This is an invaluable time saver, and beneficial to any administrator managing multiple machines.

Toad’s SQL Optimization for SQL Server is the most comprehensive tuning solution available for SQL Server environments. The SQL Optimization component offers complete SQL performance optimization with problematic SQL detection, automated SQL optimization, and benchmarking capabilities.

Major Features:

1. 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.
2. 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 work within maintenance windows in the face of growing datasets, easing the pain of meeting SLAs and reducing potential for failure.
3. Transaction Log Reader – Toad for SQL Server allows you to recover data stored in transaction log files, rolling back operations and reconstructing transactions.
4. 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.
5. 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.
6. Version Control - Toad for SQL Server provides integration with many popular version control vendors including: Visual Source Safe, Subversion and CVS.
7. 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.
8. 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.
9. 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.
10. 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.
11. Intellisense – Automate the coding process with intellisense by completing database code activity in the ‘smart’ SQL Editor window.
12. 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.
13. Grid Customization – Customize the data grid styles visible in the toolset by applying skins to the views – quickly modifiable in the Configuration wizard.
14. Visual Data Modeling – Visualize tables, dependencies and database relationships in your SQL Server environment in a data modeling view.

Enhancements: SQL Server 2005 support

Requirements:

• Client
• • PC with 600 MHz minimum
  • 512 MB RAM minimum, 768MB recommended*
  • 133 MB of disk space for installation
  • Windows 2003/XP(32-bit or x64)/Windows Vista(32-bit or x64, Ultimate edition with XP Graphics)*, Windows Server 2008
  • Microsoft .NET Framework version 2.0 or later*
  • Adobe Acrobat Reader 7.0 or later
  • Microsoft Internet Explorer 6.0 or later
  • Client connectivity and configuration for each database (pre-requisite for connecting)
  • Client tools 2005*
• Microsoft SQL-DMO version 8.0 (included if client connectivity is installed)
• • SQL Server 2000, all editions
  • SQL Server 2005, all editions
  • SQL Server Debugging - SQL Server 2005, and SQL Server 2000 with SP3