New in This Release

• 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.

Important! Toad provides support for MS SQL Server 2012 objects. Browse objects in the Object Explorer, create and alter them using Database Object Editor (DOE) or manage using Database Object Viewer (DOV) that is enabled with a right-click on the object | View Details.

Object Management

• Toad for SQL Server supports partial contained databases that were presented in MS SQL Server 2012. According to the contained databases concept all metadata, connection and configuration settings are stored inside database that provides opportunity to easily move it between SQL Server instances. Partial contained databases are introduced in SQL Server 2012 and provide limited containment functionality, but also support uncontained features available before.

  When creating a database with a help of Database Object Editor (DOE) you can select containment of the database - none or partial. You can select containment options for the databases that were set to "Partial".

  

  The contained databases are marked with a special icon in the Object Explorer.

  

• Toad allows to review the information on allocated space. Space Usage chart is displayed at the bottom of the Properties tab in the Database DOV (Database object Viewer).

  

• Toad for SQL Server supports FileTable objects that store FILESTREAM data and data related to the directories and the files. Such data can be accessed from the other Windows applications. FileTables are marked with special icon in the Object Explorer.

  

  To create FileTable right-click a Table node in the Object Explorer and select Create Table. In the Columns page set Table type to "FileTable" and specify required options.

  

• Toad allows to capture statistics on the table columns. The introduced Statistics tab can be easily accessed with a right-click on the table | View Details. Review the statistics information gathered the column specified using Statistics DOE (Database Object Editor).

  

• Columnstore indexes introduced in MS SQL Server 2012 are supported by Toad. To create a columnstore index right-click the Indexes node in the Object Explorer and select Create Index. In the General page select "Columnstore" from the Index Type list.

  

  Columnstore indexes are marked with a special icon in the Object Explorer.

  

• Stored Procedure DOE (Database Object Editor) was improved. Parameters section was updated.

• Toad allows to create user-defined server roles. Navigate to the Server Roles node under Server Security, right-click it and select Create Server Role. User-defined server roles are marked with a red icon in the Object Explorer.

  

• Sequences can now be managed in Toad. To create a sequence execute creation script in the Editor. Browse sequences under the Database node in the Object Explorer.

Session Browser

Session Browser now provides more detailed information on the processes, organized in charts. Select Tools | Monitor | Session Browser and navigate to the Charts tab. Select one or more processes from the list above and the metrics below the charts. Toad can build several charts based on the process characteristics (memory usage, physical IO, wait resource, etc.).

Database Snapshot

Creation of database snapshots can be scheduled.

Connection Manager

Toad allows to create connections to MS SQL Server 2012. Create a connection as usual in the Connection Managers pane and select the SQL Server 2012 instance from the list of available server names.

Query Builder

• This release of Toad has re-implemented the checkbox method of selecting columns in the Query Builder Diagram pane. Click a column name once in the table diagram to add the column to the query. To add the column to the query a second time, right-click the column name in the diagram and select Add to Output.

  

• The elapsed time is now displayed in the lower right corner of the Query Builder window while a query is executing.
• In the Query Builder, for the selected columns in the criteria pane, the column widths now fit the column name making it easier to read them.

Code Snippets

• You can now import snippets directly into a selected folder in the Code Snippets window.

• You can now export your entire code snippet library to a destination folder.

  

Editor

• In the Editor toolbar, all of the execute buttons are now consolidated under one button.
  • This main button retains the function of the last action for the active Editor window.
  • If you switch to another Editor window, the button will change to reflect the last execute action for that window.
  • The other execute buttons are always available beneath the Execute SQL button via a drop-down list, or can be placed back in the toolbar by customizing it.
• For all databases, the error log in the Editor and the Query Builder now provides the line and position for syntax errors. Highlighting is also included for syntax errors if the database has a deep parser.

• Previously, when the Editor contained multiple statements, and you selected Send To Query Builder, Toad sent the entire contents of the Editor. Now you can highlight one statement, right-click the statement and select Send To Query Builder to send only the one statement.

  

• Editor floating window has it's own file menu. Context menu has been redesigned so that managing SQL became even more convenient as all most likely used options are easily accessible.

• Document Recovery Manager allows to recover previously saved Editor documents. Select the document in the Document Recovery Manager pane in the right sight of the program window.

  

• Toad allows to load preset template when you open a new Editor window. It's handy when you want your scripts to be consistent with each other (for example, have the same header with company name). Create a template TOADSQLFILE.sql in the following location:

  Platform	Location
  Windows XP, Windows 2003	C:\Documents and Settings\All Users\Application Data\Quest Software\<Product_Name>\Templates\Snippets.
  Windows Vista, Windows 2008, Windows 7	C:\Users\<user>\AppData\Roaming\Quest Software\<product>\Templates\Snippets\

  Tip: Constructions surrounded with $ (for example, $Name$) in TOADSQLFILE.sql are treated as snippets in Toad.

  

• Filestream and FileTable functions are highlighted in the Editor.

• Now you can drag and drop column headers right from the Results Sets to the Editor.

  

Code Completion

• Code Completion allows to insert SELECT query results using INSERT INTO  (...) SELECT ... syntax. INSERT INTO  (...) SELECT ... is handy as you see a list of target columns with their data types. This ensures that target columns will be compatible with the ones inserted using SELECT query.

  

• Code Completion provides enhanced support of data types syntax. When operating on data types (DECLARE, INSERT, etc), Code Completion list is automatically populated with available data type lengths. When selected the attribute is also automatically wrapped in the brackets.

  

• Subqueries support has been significantly improved.

• Code Completion provides supports of USE statement. With USE statement in the script Code Completion list is be firstly populated with target database objects irrespective of the database set as default. It is handy because the objects that are most likely to be used in the query are located at the top and you do not need to scroll down a long list in order to find them.

  

• The column data types and functions and procedures parameters are shown with pale color in the Code Completion list.

  

Script Map

Script Map is easy-to-use tool that makes managing SQL scripts even more convenient and simple. Script Map pane provides fast, structured and clear representation of your script in the Editor and allows to easily manipulate statements and statement groups. By default Script Map is switched on automatically when you open a new Editor window or you can access with Editor | Windows | Script Map.

Note: Script Map has replaced Navigator feature.

Script Map supports most of SQL statements and recognizes nesting levels (code blocks, named regions, etc). For example, nesting is displayed for stored procedures, functions, etc.

• You can easily customize what statements to display in the Script Map pane. To do it select the Options button at the top of the pane. Set the colors and include only those types of statements that are relevant for you.

  

• Multi-select allows to manage several items simultaneously. For example you can cut, copy, execute several statements irrespective of their nesting level and location in the script.
• The statements that contain syntax errors are underlined red in the Script Map. The parent items that contain such statements are highlighted as well.

Data Compare

• Data Compare wizard has been significantly improved and demonstrates fast performance.

  • Map Source Objects to Target page of the Comparison Wizards has been redesigned to make column mapping easier, more convenient and user-friendly. The objects are mapped automatically, even large databases are processed almost instantly. Columns Mapped column displays how many columns are mapped and mapping status, while the information pane at the bottom shows more detailed information.

    

  • It is handy to use Search when you have a lot of objects included in the comparison. Instant search is also available in the Target Object drop-down list. When search is activated mapping commands (Map All, Map Selected, Clear Selected, etc.) are applied to the objects that match selected criteria only.

  • Now mapping activities are organized in the toolbar and are also available from the context menu.

  • When altering your comparison (without changing source or target connection properties) schema extraction is no longer performed in Change Compare wizard, this saves much time especially when comparing large databases. To extract schema select Refresh in the Map Source Objects to Target page of the Comparison Wizard.

  • Now there is Save Comparison option in both New Comparison and Change Comparison wizards. It allows to save the comparison file without actually comparing data.

• Now reviewing the comparison results and navigating between the differences in the records became more flexible and easy-to-use:

  • When refreshing comparison schema extraction is no longer performed. To refresh both schema and data select Refresh Schema and Data from the Refresh button pop-up in the Result pane toolbar.

    

  • Data is listed in the comparison key order. It is very helpful if you need to not just synchronize source with target but to understand the nature of the differences.
  • Source and target columns are shown in pairs in the Details pane. So that you can see the differences in values right in front of you. At the same time you can use Separate source and target columns to list the source columns first and all target columns after them.
  • You can navigate between the differences in the records (jump to the previous or next) within the selected column (vertical arrows) or across the whole comparison (horizontal arrows).

  • The exclamation marks in Result (top) pane and Details (middle) pane indicate that the records contain duplicated values in comparison key and require changing of comparison key (previously such records were shown as conflicts). Hover the mouse over the exclamation mark to see the tooltip with detailed information.

    

  • The rows in the Details pane are highlighted green, red and blue to indicate source only, target only and different records correspondingly.

  • When searching for the data in the Details pane you can select Search currently selected column only to search within the single column in addition to other options.

    

  • Data Compare improved working with large objects (for example tables where each record is very large, e.g. 10 or 20 MB). Entire data contained in the record is no longer loaded into RAM, that prevents interface freezing and running out of memory. Now only small piece of the data is loaded when displaying the record contents in the Details pane. Cell Viewer shows more data but also not all (approximately 4 KB), total and shown data size is also provided. To see the entire data select Show All considering that it will be loaded into RAM.

    Note: If trying to view the image that is very large (more than 5 MB), only small part of it will be shown in text form.

    

• The statements in the synchronization script are listed and processed in the following order: DELETE – UPDATE – INSERT. This order reduces the risk of constraint violations or prevents data conflicts.

Import

• Now you can import data into identity columns. When trying to import data in the table containing identity columns you will be prompted to turn on "Identity inserts" option in the Select Target page of the Data Import wizard to enable import.

  

• When importing data using the Import Wizard, you can now select to use your current regional settings instead of the default. The data is parsed using the settings of the region that you have specified (on your PC).

SharePoint

You can now export data to a list in SharePoint using Toad’s Export Wizard. You can also import a list from SharePoint using the Import Wizard. Toad supports SharePoint 2010.

..

Project Manager

• You can now easily add a database connection to a project in the Project Manager. Simply right-click a project or folder and select Add | Database Connection. Then you can right-click the connection in the Project Manager window to connect or disconnect.
• When you right-click a file and select Browse, a Windows Explorer window opens with the file already selected. This allows you to open the file, or review the file’s location and also open other items in the location folder.

• The Project Manager has a new feature to allow you to save a value for a bind variable. Then, when executing SQL containing that variable, Toad will not prompt you for the value. Use the Project Manager to manage your list of bind variables and their values.

  

Reports Designer

When you create a Data Report from data with a Master Detail relationship, the Detail Report Band is automatically inserted into the report for you.

• Information sharing between activities is improved. For example, if you delete an activity that creates a file, that file is also deleted from any tasks later in the script where it is used as an attachment or other input.
• A Cancel button has been added to the Attachment Editor so you can cancel out of the operation, even after making some modifications.

• Right-click an activity in the script design window and select Enabled to easily enable/disable the activity.

  

• In Toad, properties and script settings now display only when the activity or settings icon is selected in the design window, making it more difficult for the user to accidentally change script settings and activity properties.

• You now have the option to choose whether or not to truncate the script’s log file each time the script runs. Make the selection in the script settings pane.

  

• You can now perform a Find and Replace task on multiple files at one time by using standard wildcard symbols in the source file name in order to select multiple files. And you can still add multiple find and replace tasks to one activity.

• You can now use drag and drop or up/down arrows to change the order of find and replace tasks in the Find and Replace activity.

  

• In the Email activity, you can now select multiple files at one time using Ctrl+click.
• In the Delete File activity, when you click Add Files, the File Collection Editor correctly displays and allows you to select from the files that are created earlier in the script.

Important!

Toad includes significant enhancements to Automation that affect attributes in the actual automation script. If you open an automation script from a previous version, a message informs you that the script will be upgraded so it will work in the current version of Toad.

Caution: If you upgrade this script, it will no longer be compatible with previous versions of Toad. However, a backup copy of your script will be saved in the Automation\BAK folder in the Application Data Directory under Help | About.

Utilities

Toad now provides proxy support for FTP connections. Toad allows you to set up an HTTP or Socks proxy for an FTP connection.