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:
i. Test data is generated for ticked tables and columns,
ii. Select a table or column,
c. Set the settings for that selected table or column,
d. Preview and edit test data,
e. Generate test data,
f. Further configure and export.
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.
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.
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.
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.
Many thanks again to you all for your input and feedback with v6.6 release. And we can download new release here