Product Variants
Other product variants may be available, please contact us or
request a call back
if you cannot see what you are looking for.
Product Information
Toad® solutions enable you to do your job with increased accuracy and efficiency, Our database tool significantly improves your productivity by helping you:
•Understand your database environment through visual representations
•Meet deadlines easily with automation and smooth workflows
•Perform development and administration tasks from a single tool
•Manage more with multi-platform querying and data modeling tools
•Validate database code to ensure the best-possible performance
•Manage and share projects, templates, scripts, and more
More than 10 years of development and feedback from communities like Toad World® have made it the most powerful tool available.
Toad for SQL Server bridges the functionality gaps that exist in both Microsoft's SQL Server Management Studio and Visual Studio and it does it all within a single toolset. Toad for SQL Server allows you to:
- Compare and synchronise schema and table data
- Execute SQL scripts against multiple SQL Server instances
- Rollback transactions from SQL Server transaction logs
- Manage SQL Server agent jobs
- Recall SQL scripts run at any point in time
Documents & Downloads
» Toad for SQL Server Datasheet
» Why use Toad for SQL Server
Benefits
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 Synchronise – Compare and synchronise 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.
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.
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.
SQL Performance Optimisation – Optimal SQL performance is ensured through an automated process of identifying, optimising 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.
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 Customisation – Customise the data grid styles visible in the toolset by applying skins to the views – quickly modifiable in the Configuration wizard.
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 – Visualise tables, dependencies and database relationships in your SQL Server environment in a data modeling view.
System Req.
System Requirements:
Client PC:
- PC with 600 MHz minimum
- 512 MB RAM minimum,
- 768 MB recommended
- 130 MB of disk space for installation
- Windows 2000/2003/XP Professional (32-bit or x64)
- Windows Vista (32-bit, Ultimate edition with XP graphics)
- Microsoft .NET Framework Version 2.0 or later
- Microsoft Data Access
- Components (MDAC)
- Microsoft Internet Explorer 6.0 or later
- Acrobat Reader 5.0 or later
- VGA monitor with a minimum resolution of 800x600, 1024x768 recommended
- Mouse pointing device
- Client connectivity and configuration for each database (prerequisite for connecting)
- Microsoft SQL-DMO version 8.0 (included if client connectivity is installed)
Server:
- SQL Server 2000, SP3
- SQL Server 2005 SP2, all editions.