Updates to Toad for SQL Server

Version 3.2

General

• Performance Improvements?We are excited to announce major memory improvements for queries that return large result sets in the Editor result sets and the Database Browser Data tab! The memory only increases by a couple of megabytes initially regardless of the size of the result set. Subsequent scrolling of the result set only reads into memory what is needed to display.

• Default window to open when connecting—A separate window no longer prompts you to associate a default window to open when initially connecting to Toad. You now specify the default window to open in the Configuration wizard.

Query Development

• Editor:
  • View scripts in a full size window?Use docking controls to auto-hide or group the Editor panel, Code Navigator, and result sets. To display the Editor and Results panels in a separate, full size window, drag-and-drop the Results tab into the Editor window. Press F6 to switch between the two panels.
  • Error line highlighting?Ability to highlight the line in the Editor that caused an execution error. To do this, double-click the error message in the Script Output tab.
  • Change case and add comments?You can now change the case of text or comment or uncomment a line by selecting Editor | Advanced or from the Editor's right-click menu.
• Query Builder:
  • From clause subquery support?You can now add a subquery to a From Clause using the Query Builder toolbar or the right-click menu. A Queries panel displays on the left side of the window with the From Clause subquery. You can add tables and views and create joins the same way you normally use the Query Builder.
    
    After creating the subquery, click the parent query in the Queries panel to return to the original query. A From Clause Subquery table now displays in the Diagram panel with all the columns in the subquery. Use this new table as you would any other database object.

  • Date ranges?When you add a Where condition for a column that uses a DateTime data type, a new Date Range tab displays in the Where Condition window. The Date Range tab allows you to select a plain text tag such as, “Today,” “Last week,” “Last 30 days,” and “Current year.” The tag you select is added to the Where condition of your query and when executed, is substituted with a BETWEEN command using the appropriate date range. Date Range tags can also be used in the Editor so you can create queries manually.
    
    Date Range tags are also useful when executing SQL statements from Automation. You no longer have to edit regularly executed queries to change a date range when you need to retrieve data every month for the previous month.

Database Administration

• Generate SQL drop script?You can now select Drop Script from the Generate SQL right-click menu in the Database Browser or Object Palette.

• Generate SQL retains Formatter settings?When using the right-click menu to generate SQL in the Database Browser or Object Palette, the settings specified in the Formatter Options pages are now retained.

• Log Reader?Log Reader server components are now supported on x64 servers and Windows Vista.

• Data Compare?Provides the ability to:
  • Compare tables and views that have different owners, different names, or different column names.
  • Compare tables that do not have primary keys.
  • Compare specific columns of a table.
  • Change Data Compare project parameters through the Change Data wizard.
  • Connections listed in Data Compare are better integrated with environment in that it now displays connections based on the connections in the Connection Manager.

Data Management

• Grid Customization?You can now customize the grid style when a skin is applied to
  Toad. You can modify this setting in the Configuration wizard (Tools | Configuration
  Wizard) or in Interface Options (Tools | Options | Environment | Interface).

• Read-only data?You can now set an option to make all data grids read-only by default.

• Search data?Ability to search data grids for word or phrase matches by pressing CTRL+F. Clicking Mark All in the Find window highlights all cells in the grid that match the find criteria.

Version Control

• Added support for the following additional version control providers:

  • Subversion

  • CVS

For a complete list of features: Toad for SQL Server