Team Coding has been redesigned to improve overall performance, usability, and stability, and to better
support Agile database development.
IMPORTANT! The 12.9 implementation of Team Coding is not backward compatible with earlier versions of Toad.
Version 12.9 can read a Team Coding environment that was created with an earlier version, but the earlier
versions cannot read a Team Coding environment that is created in version 12.9.
The following are some of the major enhancements in Team Coding:
-Team Coding was moved from the Utilities menu to the main menu (by default). Captions and ordering
were changed. You may need to reset the toolbars to see these changes.
-Team Coding, including synchronization functions, now performs much faster.
-Migration of Toad 12.6 and earlier Team Coding settings perform much faster.
-Code Tester is now integrated into Team Coding. You can set this option on the Team Settings tab of the
Team Coding Configuration window.
-Team Coding now detects when the source code for a database object has been changed outside of
Team Coding between when it was checked out and when it is about to be compiled back into the
database.
-Team Coding now supports Microsoft Visual Studio Team Services Online. See the online help for setup.
-See the online help for complete details about Team Coding.
Automation Designer
-Code Tester was added to Automation Designer:
-A Code Tester action was added to the DB Misc tab in the Automation Designer.
-From this interface, you can run test suites, unit tests, and test cases defined in Code Tester.
-A script source can now be a script that has been published to Toad Intelligence Central. Output can be
discarded or published back onto the Toad Intelligence Central server.
Export Dataset
-A new Select Statements (from dual) export format was added. This creates a select statement from
dual(or multiple select statements from dual, UNION ALL'd together) so you can reproduce a particular
dataset from a query without the original tables.
-When exporting from a grid with a range of columns selected, you can now right-click on the Columns to
Exclude dropdown and select Include only selected columns. Non-selected columns are excluded
from the export.
-Sheet Name is now a drop-down menu, and a <table name> option was added to enable the title
of each Excel sheet to match the name of the table it contains.
Debugging
-Changes were made to better handle input and output of composite types.
-When debugging a trigger you can now select the triggering event to generate statements of the
appropriate type in the anonymous block.
Schema Browser
-A Constraints tab was added on the right-hand side for Views.
-Partition and Subpartition tabs now have a button to rename the selected partition or subpartition.
-Scripts, CREATE/ALTER dialogs, and Compare Schema now support the PURGE clause for
Materialized View Logs
-When you select more than two objects and select Compare with another object, those objects are
now sent to Compare Schemas or Compare Databases with the window filtered to only those objects on
the Object Set tab. You need only select the target schema and database, then click the green arrow
to run the comparison.
-The Rebuild Table window has new options to add and edit columns from the Columns tab.
-Compare Schema has the following enhancements:
-Extra/Missing columns will now generate a row for the table under Objects which differ.
Columns are still listed under in one schema but not the other.
-Added a filter to the Results tab. You can filter by object name or type of difference. To make
room for the filter, the Group by object type checkbox was removed from the toolbar, but is
still available as a right-click item on the results tree.
-You can now right-click on a table in the Results tab and then send it to a Rebuild Table window
or DBMS Redefinition Wizard.
Editor
-A new Treat blank line as statement terminator option was added to Toad Options | Editor |
Execute/Compile. When checked, it is no longer necessary to properly terminate statements with a
semicolon, as long as a blank line exists between statements.
-A Team Coding toolbar was added to the Editor and is active when there is a script or file open. A Team
Coding tab was also added.
-There is a new button on the Script Output tab of the Editor that will export all of the grids to a single
Excel file.
*******
Additional information relating to the new features in version 12.9 can be found in the Toad for Oracle 12.9 Release Notes or in the 'New in this release' subtopic in the 'Welcome to Toad' Chapter of the Help. (includes instructions and screenshots)
