Dell Toad DBA Suite for SQL.Server 6.6
Run faster, more reliable databases by doing more work in less time. As a single toolset, Toad for SQL Server database management tool maximizes productivity through extensive automation, intuitive workflows and built-in expertise. Plus, it complements Microsoft tools by solving key SQL Server challenges, so you can proactively manage many databases. Easily resolve issues, manage change and promote the highest levels of code quality, performance and maintainability.
Query builder
Enable DBAs and analysts to easily export to their favorite tools. Access key data quickly (including built-in report and pivot functionality) for in-place analysis and single-click export to an Excel instance.
Compare and sync
Easily identify differences by comparing and syncing servers, schemas and data.
Log reader
Roll back transactions in the transaction log without restoring from a backup.
SQL optimizer
Conduct application performance tuning with automated query rewrites and optimization.
Automation
Automate repetitive processes, including data and schema comparisons.
SQL script recall
Save time by eliminating the need to retype commonly used SQL and T-SQL statements. Track any SQL executed during your Toad session.
Group execute
Process scripts and code snippets against multiple servers and instances.
Security management
Create, manage and even replicate security for all users by building and executing security-related scripts against multiple servers.
Report generation and documentation
Develop customized reports for administration and development, and export those reports in flexible formats, including .xls, XML, .doc and .pdf.
Object search
Rapidly locate code to quickly assess the impact of renaming or code changes by searching for text in database objects (such as column names and SQL code).
Project management
Save and reuse powerful features for object management, SQL and T-SQL coding.
T-SQL editing
Reduce the T-SQL learning curve, introduce consistency and help deliver high-quality code. Simplify SQL coding with advanced code complete, code snippets and SQL recall.
Consistent toolset
Minimize the learning curve across multiple platforms. Enjoy a similar look and feel while receiving deep functional expertise for the nuances of each platform.
RELEASE NOTES:
New Features in 6.6:
Test Data Generator
Use the Test Data Generator to generate realistic test data to load into your databases.
- To open the test data generator click File | New | Data Generator
- Create a Test Data Generator project.
- Set the scope of the project by setting the Toad for SQL Server connection and database schema.
- In the test data generator window:
- Test data is generated for ticked tables and columns,
- Select a table or column,
- Set the settings for that selected table or column,
- Preview and edit test data,
- Generate test data,
- Further configure and export.
Query Development:
Background Processes
The Background Processes pane now identifies the Query Builder or Editor document window (if any) associated with a running process. If you have multiple statements executing simultaneously, this makes it easier to match a running process to its associated document. Click the running process in the Background Processes pane to display the associated document window.
In addition, for each Query Builder or Editor document with an active background process, an animated progress icon displays in the window's tab. This allows you to quickly see which windows have executing statements.
Analyze Joins
Toad now provides a tool to help you analyze and visualize joins in the Query Builder or a Database Diagram. After building a query or a diagram, click the join between two tables in a diagram. Toad profiles the data based on the relationship between the tables and presents the information in a Venn diagram. Click a section of the diagram to view the values represented by that section. The Venn diagram also indicates if a join is a Cartesian join. This gives you the opportunity to modify the join before executing the query.
Sort Columns
You can now sort columns in a table diagram in the Query Builder. Right-click a table and select Sort. This is useful for finding a column when the table or view has a large number of fields.
View PDF Files in LOB Viewer
You can now view PDF files in the LOB viewing pane in the Database Explorer, SQL Editor, or Query Builder. In the Data tab or Result Sets tab, in a LOB column, open the drop-down LOB viewing pane. If the LOB is a .pdf file, it is displayed in the PDF tab.
Automation:
Throw Error Activity
Automation includes a new activity that allows you generate an error and add a custom error message to the script execution log. In addition, you can instruct Toad to stop or continue after the error is logged. This can be useful if you want to terminate the script when a condition exists that would not normally cause an error.
Automation Reports and Container Activities
In activities that allow you to select files created in previous activities in a script, reports generated in container activities are now visible in the File Collection Editor.
HOMEPAGE
Download link:
Links are Interchangeable - No Password - Single Extraction
