Team Coding: Team Coding is the source control feature that helps development teams manage code changes in database with the confidence of not overwriting the changes of other team members. Toad uses the Editor to control access to the Database objects (Views, Functions, Procedures, Packages, Triggers and Types), based on their check-out status in Team Coding. Some fun facts about Team Coding:

  • Configuration for Team Coding is done only once in a database. No separate configuration for each Toad user.
  • Team Coding supports multiple version control systems natively: CVS, ClearCase, Microsoft TFS, Perforce and SVN. Support is also available for other version control systems, provided they have the SCC compatibility.
  • Team Coding can be used without Version control system as well. This mode will provide the basic check-in check-out status visibility, to prevent any code overrides and monitor the database changes. However, we suggest that you use Team Coding with the version control system to fully experience the benefits of the code development in team environment and ability to view the history of the changes.

Generic How to setup Team Coding: This document has 2 main sections:

  1. Team Coding – basic check out and check in functionality
  2. Code Collections – groups the database objects (by object type or object names). Ease of use for managing large code base.

Please refer to the next blog in the series for Integrating Microsoft TFS with Team Coding

 

Setup Team Coding:

The setup for Team Coding creates the Team Coding metadata in the schema selected (recommended schema – TOAD). The metadata provides the functionality for the team to work on the shared environment without the risk of overwriting the changes made by other developers. Database user with DBA privileges is needed to install Team Coding.

Steps:

Select Configure Team Coding:

Following message will appear. Click OK:

  

Click on Install Team Coding:

It is preferable to install Team Coding objects in standard TOAD schema. Select the tablespaces for the Team coding metadata. The database role TC_ADMIN_ROLE is used for:

  1. Edit Team Coding Configuration
  2. Edit Code Collections
  3. Freeze Team Coding Objects
  4. Break another user’s Team Coding lock

 

The script to generate the Team Coding Objects will be displayed on screen. Click Execute:

Enter the password for the TOAD database user:

  

Installation for Team Coding is completed (took less than a minute):

  

Now the database is configured to use Team Coding across all the schemas. Above steps are needed to be completed only once per database. Click on “Enable Team Coding for this Database”:

  

This setup is the basic setup, where working on a single object at a time gives enough control. Once you check out any object, it is available in Team Coding Dashboard.

  

 

Setup Code Collections:

Code Collection is a group of database objects that will be controlled by Team Coding. So, let’s say you are currently working on all the database objects in schema “QUEST_PERF” and want all the objects to be integrated with Team Coding as a collection. You would create a code collection that will define the scope of the database objects available in the Team Coding Dashboard.

Steps:

Select menu option: “Configure Team Coding”

  

Select “use Code Collections” and click OK:

  

Click yes below to create the Code Collection:

  

This will open up Team Coding Dashboard. Add the collection name and the criteria for selecting the objects for that collection:

  

Sample screen below shows 2 code collections created in the Team Coding Dashboard:

  

First time opening the Controlled Objects will display following message:

  

Start Checking Out the objects and they will start appearing in the Team Coding Dashboard:

  

After Team Coding setup, there will be Team Coding toolbars and right click menus available in Schema Browser and Editor for interacting with Database objects using Team Coding and perform Check-in , Check-Outs and check their status in the Team Coding Dashboard.

Hope you have fun exploring the benefits and ease of working in the shared development environment using Team Coding.