Toad for SQL Server 4.5.0.854

Toad for SQL Server 4.5.0.854 is powerfully effective tool built around a single integrated SQL, T-SQL, and Procedure Editor. Using Toad, developers can build and test T-SQL code and can use the Browser to quickly access, create and edit database objects.

Toad for SQL Server empowers SQL Server developers and administrators to develop code more efficiently. It also provides utilities to compare, extract and search for objects, manage projects, import/export data and administer the database. Toad for SQL Server increases developer productivity and offers access to a solid community of experts and peers for interactive support.

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.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.
6. Version Control - Toad for SQL Server provides integration with many popular version control vendors including: Visual Source Safe, Subversion and CVS.Intellisense – Automate the coding process with intellisense by completing database code activity in the ‘smart’ SQL Editor window.
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.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.
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.Grid Customization – Customize the data grid styles visible in the toolset by applying skins to the views – quickly modifiable in the Configuration wizard.
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.Visual Data Modeling – Visualize tables, dependencies and database relationships in your SQL Server environment in a data modeling view.
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: provide support for SQL Server 2008 and a faster connection time when creating new connections.

Requirements:

• Client
• • PC with 600 MHz minimum
  • 512 MB RAM minimum, 1 GB recommended*
  • 104 MB of disk space required to run Toad
  • Windows 2003/XP(32-bit or x64)/Windows Vista(32-bit or x64), Windows 7(32-bit), Windows Server 2008
  • Microsoft .NET Framework version 3.5 SP1 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)
  • SQL Server Client Tools
• Special Notes:
• • SQL Server Compact Edition is not supported
  • The memory required may vary based on the following:
  • • Applications that are running on your system when using Toad
    • Size and complexity of the database
    • Amount of database activity
    • Number of concurrent users accessing the database