Team Coding

New Feature - Auto Add Objects to Team Coding from a Script

Toad can now automatically add a list of objects to Team Coding when running a script to create the objects. The objects must be controlled by a Code Collection.

1. Go to Options Source Control Team Coding.
2. Select Automatic Team Coding Actions - Add to Team Coding when loading/creating an object/ file.
3. Load a script with multiple objects that are controlled by Code Collections.
4. Run the script (F5).
5. Enter a comment in the Add to Archive dialog, and click OK.
6. Open or refresh the Team Coding viewer. The newly created objects are listed in the Viewer. If Third Party VCS is in use, the object source is added to the VCS Project for the Code Collection.

Team Foundation Server (TFS) alternate URL

You can now enter an alternative URL if your Team Project Collection has a non-standard URL that cannot be correctly built using Toad’s TFS configuration settings.

When this value is set, Toad ignores all the other settings (server, port, collection, virtual dir, etc.) and uses the alternate URL to build TFS calls to the Team Project Collection on the server.

It is recommended that this is only used in the very small number of cases where the URL to the Team Project Collection is not configurable from the normal Toad settings.

Note: In this build, this is only available for the TFS internal client.

• Schema Browser Team Coding Menu
  • There is now a ‘Team Coding’ menu for controlled objects with the Team Coding status displayed in parentheses.
  • The Team Coding sub-menu displays all Team Coding menu items, with only the available items selected.
• Team Coding Status is now displayed in the Schema Browser status bar.
• Schema Browser and Editor Team Coding Tab:
  • The Schema Browser and Editor now include a Team Coding Tab for controlled objects. This tab displays Team Coding Details, and Team Coding/Code Analysis details if the option is used.
  • If Version Control integration is used, revision history is included. The view differences window may be opened from the Team Coding Tab.
• Add to Schema Browser Favorites:
  • Objects controlled by Team Coding may be added to the Schema Browser Favorites window.
  • The new menu item / toolbar button in the Schema Browser Favorites window launches the Team Coding Dashboard with an ‘Add to Schema Browser Favorites’ menu item enabled.
  • Code Collections/Objects may be selected and added to the Team Coding Dashboard output window.
• Option to Automatically Add Object to Team Coding when opening in the Editor/Schema Browser:
  • An Option to automatically add objects has been added to Options Source Control Team Coding.
  • If this option is set , an object is automatically added to Team Coding / VCS if the object source is opened in the Editor.
  • There is a prompt to add option prompts before adding the object automatically.

N/A

There are new options in Export DDL and in Generate Schema Script to include result_cache, flash_cache, and cell_flash_cache.

You can now specify that these are always included, never included, or only included when non-default.

A sub-option has been added to the script to execute on new connection feature. In View Options StartUp there is a check-box to also execute that script for each new session that is created as a result of threaded query execution.

The default is unchecked.

The script will execute in the background and provide no indication of success, but if there are any errors raised, you'll be notified with the ability to look at the script output.

Bind and substitution variables can be mapped to environment variables.

In the Variables dialog:

• If 'Literal' is checked, the value you typed is used.
• If 'Environment Variable' is checked, the value you type is treated as the name of an environment variable.

The value of the variable is used when the query is executed. Simply use the name of the variable; do not wrap it in %'s.

Example: If the value of PATH is desired, check 'Environment Variable' and enter PATH as the value.

Bind/substitution variable support has been added. It supports mapping variables to environment variables as mentioned above.

1. Go to the 'Dataset' tab.
2. When the exported dataset is a query, click the 'Set Variables' button to set values for any bind/substitution variables in your query.

Data Generation now has the ability to create SQL*Loader control files for loading data from the command-line.

To generate a SQL*Loader control file:

1. Set your table and field options within the Generate Data window as you normally would.
2. On the Generate Data window toolbar, click the 'Create SQL*Loader Control File' button A separate control file will be created for each table selected in the Generate Data window.

Email notifications and the Email Action in the Automation Designer now support SSL/TLS so you can use services such as Gmail and other providers.

To configure global settings:

1. Go to View Toad Options Email Settings.
2. Click Use SSL and click OK.

To configure Email Action settings:

1. Go to 'Automation Designer' Utilities (tab) 'Email' (double-click the icon).
2. Double-click the new Email Action to open its properties.

3. Near the bottom of the Properties window, click Use SSL.

   Note:

   • In the next beta, the Email Action will take its setting from the global settings in Toad Options.
   • You can de-select Use SSL in the Email Action’s properties, and that will not affect the global settings in Toad Options.

You can use edit controls for managing the list of recipients consistent with email clients.

• Recipients can be delimited by comma or semicolon.
• The user-name property of the outgoing mail server is no longer a required field. Not all mail servers require it.
• The 'Password Required' check-box has been removed. If no password is required then don't enter one.

A new bar button is added just to the right of the Make/Strip Code code for the refactoring items.

Restoration of toolbar or manual addition is required to see it.

Clicking the drop-down will show all available items. Clicking the button will invoke the most recently used refactoring item.

This release includes unspecified bug fixes.

QSR has been renamed TSR (Toad Script Runner).

Added a new 'Support Portal' category and renamed 'Knowledge Base' to 'Knowledge Articles'.

Toad's Help Documentation now has its own category.

Option added to exclude public synonyms having a name starting with a forward slash. Duo princess english patch download.

The option is a child check-box of the Public Synonyms option on the Options Editor Code Assist options page in the Toad Insight Objects box.

Options added to apply various refactoring features to the SQL prior to optimization. The refactoring features include:

• Correct WHERE clause indentation level.
• Convert DECODE function to CASE statement.
• Remove subqueries.

Starting with this beta, license keys compatible with Toad for Oracle 9.7 and earlier are no longer supported.

These keys will need to be upgraded to keys compatible with Toad 12.5 and later.

If you're presented with the licensing window in the current beta, you will need to upgrade your key using the following procedure:

1. Locate your license number.

   This number can be found in the licensing window of your Toad 12.1 installation. If not explicitly listed, it may be included as part of the Site Message associated with your key (Example: ACCOUNTNAME-nnn-nnn-nnn).

2. Go to the License Upgrade page (http://license.quest.com/upgrade).
3. Enter your e-mail address and your existing license number, and follow the prompts on the screen.

If you have trouble finding your license number, or have difficulty obtaining an upgraded key, please contact the License Administration team (https://support.quest.com/LicenseKey.aspx) for assistance.

Added the option of importing and exporting Toad's user files as a single compressed file.

• Go to Utilities Copy User Settings Import or export a Toad settings file.

These new scheduler job types are now supported in the Create/Alter program and Create/Alter scheduler job windows:

• EXTERNAL_SCRIPT
• SQL_SCRIPT
• BACKUP_SCRIPT

In support of these, the Scheduler Credential object is also now supported in Toad. This object type now has a tab/dropdown-entry/tree-entry in the Schema Browser. It also has a Create/Alter window. Support for credentials has been added to:

• Schema Compare
• Generate Schema Script
• HTML Schema Doc Generator
• Project Manager
• …and everywhere else it made sense to add them.

Added support for 12c's new DBA_OBJECT_USAGE view in Toad's Index Monitoring window.

Previously, to use this window with indexes in other schemas, SELECT privileges on several SYS tables were required.

Now, only the SELECT privilege on the new DBA_OBJECT_USAGE view is required.

This release includes unspecified bug fixes.

Added interface for Serena PVCS Version Manager.

• Support for PVCS Version manager Command Line Interface (CLI). PVCS Command Line option must be included when installing PVCS.
• PVCS is now supported with Team Coding.
• PVCS is now supported in 64-bit Toad.
• Replaces existing Merant PVCS interfaces.
• Tested with Serena PVCS Version Manager 8.5/ 8.4.

This and interim releases include bug fixes.

Cancellation of Code Insight implemented.

• Pressing ESC will cancel Code Insight while it is loading and close it if it's already loaded and displaying results.
  • The population of Code Insight requires execution of multiple queries as well as parsing of the Editor text. All query execution is now threaded.
  • Results display in the pop-up as they are available.

A new 'Online' option disables access to the Repository.

1. Select OptionsOnlineScript RepositoryDisabled, to use the previous Windows XP style Open and Save dialogs.
2. Select Toad World or Private to use the new Open and Save dialogs.

Changes were made to support the importing of LDAP connections.

Previously, this was not possible because the Database Browser's tree had Database nodes as child nodes of Server nodes, and server information is not available from LDAP.

Now the Database Browser has columns for Server, Database, Comments, and 'Last Connected'. It would be easy to add more columns at this point if desired.

• To import from LDAP, click the folder icon, then 'Load databases to tree.'

12.5.0.4-11/4/2013

New options have been added to the end of the 'Create Pluggable Database' dialog to:

• Automatically add the new entry to your tnsnames file
• Add a new node to the database browser tree
• Start the new database.

12.5.0.2- 10/14/2013

Team Coding / Code Analysis integration has an option to prevent check in where an object fails to meet Code Analysis specifications.

To enable:

1. Go to Configure Team Coding

2. Select both options:
   • Use Version Control System (VCS)
   • Use Code Analysis
3. Click Configure.
4. Select one or both options under Prevent Check-in:
   • Prevent check-in on failed validation metrics
   • Prevent check-in on metrics lower than check-out

If you also select Display warning dialog on validation failures, then a dialog with details of errors will display on validation errors, otherwise a validation error message will display in the output window.