Return
-
Title
What's New in Toad for SQL Server 6.7? -
Description
This article discusses what the new features are in Toad for SQL Server 6.7 -
Resolution
Health Checks and Spotlight DeveloperMonitoring of your SQL Server instances and health check analysis has moved from Toad for SQL Server to Spotlight Developer. Spotlight Developer is a free tool which you can download from the Spotlight Essentials web site.Query DevelopmentPopulate Where Clause with Values from FileIf you are using IN or NOT IN in a WHERE clause, you can now load multiple values from a .txt, Excel, or .csv file.•In the Query Builder, use the Where Condition editor to select the file containing values.After the file is uploaded, the values are automatically added to the Where clause. Click the down arrow to display the loaded values or to deselect some values.•In the SQL Editor, select Get values from file in the code completion list. Then browse to and select the file containing values.Display Multiple Results in a Single Grid•When a query returns multiple results, you can now display all results in a single grid. When multiple results are displayed in a single tab, select All results to display all result sets in a single grid, or use CRTL+Click to display only the selected sets.To enable/disable this feature, go to Tools | Options | Database | Script Result. Select All in one tab and then select Enable all results view.Background Processes Icon•The animated background processes icon has been enhanced to provide a clearer indication that a window is associated with a currently running process.For each Query Builder or Editor document with an active background process, this animated icon displays in the window's tab. This allows you to quickly see which windows have executing statements.Database ManagementData Compare•The Data Compare project file has a new XML format. The file extension (.dcp) remains the same. New Data Compare projects you create are saved using this new XML format. Data Compare files created in previous versions of Toad are supported. However, if you open a Data Compare file created in a previous version of Toad, the file is converted to the new XML format.Important: Beginning with this release, if you create or modify a Data Compare project in an Automation script that runs against a password-protected database, you must save the password in the Toad connection. To save the password, right-click the connection in the Connection/Navigation Manager and select Properties. Enter the password and select the Save Password option.AutomationSend Email Activity - Authentication in Non-SSL Connection•You can now use the Email Server Settings dialog in the Send Email activity to authenticate your connection even if you are not using an SSL/TLS connection. Previously, the User name and Password fields in this dialog were enabled only when the Use Secure SSL/TLS connection option was selected.Now, you can enter a user name and password to authenticate with non-SSL connection.Data Compare Activity•The Data Compare activity now includes a variable that returns True or False based on the outcome of the comparison. This allows you to easily determine whether or not the comparison was equal without reviewing the generated report. In addition, you can use the variable to trigger other tasks later in the script, such as with an If Condition activity.Run Program Activity•A return code (exit code) with a value of 16384 (4000 hex) or larger is no longer treated as an error by the Run activity.Background: In the previous release, any non-zero return code (exit code) was treated as an error by the Run activity. So if you used any non-zero exit code returned by your program (and assigned to the Return Code Variable) to determine actions in a subsequent activity, your script would also generate an error. Also, this method required disabling the Stop on Error option for the activity or script.Now, when a non-zero code is returned, you can use your program to generate a custom return code and specify a value of 16384 (4000 hex) or larger. This value will not generate a script error. In addition, if you use this method you can enable the Stop on Error option for the activity or script, if necessary.ConnectionsPassive Mode is Available for FTP Connections•You can now use Passive mode for an FTP connection. When defining a new FTP connection or modifying an existing one, select Passive from the Mode drop-down list in the Connection Properties dialog.The LibraryThis release includes a new interface for organizing and accessing your Toad files—the Library.•Adding files to the Library is easy. Open the Library (Tools | Library). Click Add to Library and then browse to and select one or more files. You can also drag files or a directory to the Library window to add files.•When you add a file to the Library, you can add tags and a topic to the file to make it easier to search for the file within the Library. You can also group and filter files by tags and topics in the Library.•Each file is added to the Library, but remains in its original location. A reference to the file is added to the Library and includes the file name, file path, file type, date created, and date modified.Version Control for FilesThis release has re-implemented version control for Toad files. Toad can integrate with your existing version control system allowing you to manage multiple versions of Toad files.•After you integrate Toad for SQL Server with your version control system, you can perform version control tasks directly from within Toad for SQL Server, such as commit your changes or retrieve the latest file revision from the remote repository.•Toad supports Apache Subversion™ for managing Toad files. Toad has been tested with Subversion 1.7.5 and 1.8.•You can manage the following file types using version control within Toad for SQL Server: Editor (.tef, .sql, .txt), Query Builder (.tsm), ER Diagram (.ter), and Automation (.tas).*******Additional information relating to the new features in version 6.7 can be found in the Toad for SQL Server 6.7 Release Notes or in the 'New in this release' subtopic in the 'Welcome to Toad' Chapter of the Help. (includes instructions and screenshots)