Softpedia >Windows >Internet >Servers >Database Utils >TOAD for SQL Server >  Changelog

TOAD for SQL Server Changelog

What's new in TOAD for SQL Server 6.1.0.1759

Jul 4, 2014
  • New Features:
  • Database Administration:
  • Object Explorer:
  • The Generate SQL | statement/script sub-menu now has a new option, Append To Editor. Use this command to add the generated SQL statement or script to the Editor at the location of your cursor within the Editor pane.
  • The Tables tab now includes a Last Updated column. To display the column, right-click a column header and select Options | Extra Columns | Last Updated.
  • Object Management:
  • When detaching a database, Toad for SQL Server now includes the "SET SINGLE_USER" syntax in the script to put the database in single-user mode.
  • You can now generate a Data Script from the Export menu. Select Tools | Export | Data Script. The Generate Data Script dialog opens for the select database.
  • In the Alter Table dialog, the Columns page now supports multi-select on columns. Ctrl + click to select multiple columns. Then click the UP or DOWN arrows to move all selected columns.
  • Connection Manager :
  • You can now add parameters to a SQL Server connection in the Connection Properties dialog. Toad for SQL Server includes the application name parameter with value "Toad for SQL Server" by default. You can add additional parameters if needed.
  • Query Development:
  • Editor:
  • You can now easily select and execute the code within a single region of a script. In the Editor, right-click within the script region you want to execute and select Select Current Region. Then press F5 to execute the code.
  • If you select the Include Actual Execution Plan option when executing SQL, in the Execution Plan window the tab now reads "Actual Plan" to indicate the actual plan is displayed. When the option is deselected, the tab reads "Estimated Plan" indicating the estimated plan is displayed.
  • The SQL Server 2012 SQL statement CREATE SEQUENCE is now included in the Code Snippets.

New in TOAD for SQL Server 5.7.0.605 (Jul 23, 2012)

  • Toad has significantly improved performance and stability. When working with the databases that include a great number of objects, the possibility of getting OutOfMemory exception is minimized. The costly I/O operations are now processed faster.
  • Now you can disallow Toad from connecting to the Internet if it is prohibited by your company's policy. Select Tools | Options | Environment | Security and check "Do not allow any Internet access from Toad" option.
  • Toad's interface became more customizable. Dual monitor support is now available. Enjoy! The document windows and panes can be used in the floating mode. For example, you can drag Editor as a separate document to another screen.
  • You can also arrange the layout so that the tab headers are located one under another. Select Tools | Options | Interface and check "Display document tab headers vertically" option.
  • You can now customize data filtering in the DOV (Database Object Viewer) to organize columns in ascending or descending order. Select the Filter icon in the Data tab of the DOV and navigate to the Order By page in the Filter Data pane. By default Ascending mode is on, to sort columns in descending order clear the checkbox next to selected columns.
  • When updating data in the Data Grid the UPDATE statement is issued only for the columns affected. This operation is more time-saving and prevents the loss of partition keys in the converted databases.

New in TOAD for SQL Server 3.2.0.325 (Dec 12, 2007)

  • Performance Improvements: 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.
  • 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.
  • Editor: 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.
  • Editor: 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.
  • Query Builder: 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.
  • Database Administration: 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.
  • Database Administration: Log Reader�Log Reader server components are now supported on x64 servers and Windows Vista.
  • Database Administration: 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).
  • Data Management: Read-only data�You can now set an option to make all data grids read-only by default.
  • Data Management: 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.