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:
Generic How to setup Team Coding: This document has 2 main sections:
Please refer to the next blog in the series for Integrating Microsoft TFS with 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.
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:
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.
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.
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.