SQL Navigator for Oracle 7.6 - User Guide

Team Projects

Team Projects determine which objects are controlled by Team Coding. If you are a Team Coding Administrator (meaning that you have the TC_ADMIN_ROLE) you can create one or more Team Projects to group the controlled objects into logical work units, based on your organization's workflow requirements. To use Team Coding there must be at least one Team Project.

When a version control system (VCS) is being used in Team Coding, you can link a Team Project to a project in the VCS. This linking determines where the object source revisions of the Team Project are managed in the VCS.

SQL Navigator enables you to create one or more sub-directories in a VCS project at the same time that you create a Team Project. This feature is helpful if, for example:

• You plan to use multiple Team Projects and want to mirror each one to its own VCS directory under a common root VCS project.
• You have multiple developers or development teams working on the same Team Project, and you want to isolate their objects into dedicated directories within a common root project.

Use Team Projects page of Team Coding Administration to administer your Team Projects. Only a Team Coding Administrator can administer Team Projects.

1. If using a version control system with Team Coding, log into the VCS from Team Coding | VCS Logon.
2. Go to Team Coding | Administer.
3. Select the Team Projects tab.

To Create a Team Project

See Setup Team Projects.

To change a Team Project

Under the Team Project that you want to change, do one of the following:

• To change the name of the project, right click the name and then select Rename Team Project.
• To edit the controlled database objects, click in the field next to Database Objects, then click the arrow to select the schema that you want to edit. Refer to Setup Team Projects for information about how to complete these fields and apply the changes.
• To make a project active (meaning Team Coding is active for the objects specified in the project) or inactive (deactivate Team Coding for those objects), select or deselect the Active box.

To delete a Team Project

1. Select the Team Project to delete.
2. Click to delete the project, or right-click the project and select Delete Team Project.
3. Click Apply.

To freeze a Team Project

1. Select the Team Project to freeze.
2. Click to freeze the project, or right click the project and select Freeze Team Project.
3. Click Apply.

Note: In the Team Projects list, the project is now marked (Frozen) rather than (Active). Click to unfreeze the project.

To work with revisions

The Team Coding Administrator can perform the following actions for a project:

Icon	Action	Description
(Disabled if a VCS is not being used)	Synchronize Changes	Synchronize differences between the version in the database and the version in the VCS. Select the objects that you want to synchronize. Synchronize resolves the following issues: Differences between the VCS source code and the object in the database. Any differences are resolved by the global setting of the "When differences in source versions exist" option in the Team Coding Administrator window (as configured by a Team Coding Administrator). If the option is set to Prompt User (user chooses between opening the database version or the VCS version) a non-administrator user can make that choice. Otherwise, either the database or VCS version is opened, depending on the global setting. See Set Team Coding Global Settings for more information. Objects in the database but not in the VCS are added to the VCS. Objects in the VCS but not in the database are added to the database.
(Disabled if a VCS is not being used)	Create New Revision in the VCS	Create a new revision in the VCS for all controlled objects. This action loads all of the objects for a Team Project into the Synchronize window. Select the ones for which you want to make a new revision.
	Compile PL/SQL Objects in DB	Compile the selected object in the database.

Setup Team Projects

The Team Coding Administrator must create at least one Team Project before users begin to use Team Coding. A Team Project is linked to specific controlled objects and a version control system (VCS), if one is being used with Team Coding.

Team Coding must be installed and set up before Team Projects can be created. For more information, see Install Team Coding.

To create a Team Project

1. If using a version control system with Team Coding, log into the VCS from Team Coding | VCS Login.
2. Select Team Coding | Administer.
3. Select the Team Projects tab.
4. Click in the Team Coding Administration toolbar.
5. Assign a name to the Team Project. Note: You can rename a project at any time: Right-click the name and then select Rename Team Project.
6. Do one of the following:
   • If you are not using a VCS with Team Coding, leave the VCS area set to the default (blank).
   • If you are using a VCS with Team Coding, click next to VCS Project to specify a project (and sub-project as needed) in the VCS. The selected project will contain the revisions made to the source objects that this Team Project will control. You have the following options when selecting this directory:

7. Click to do one of the following:
   • Select All Schemas to include all of the user schemas in the database in this Team Project.
   • Select an individual schema from the list.
   • To add another schema, click and then select a schema.
   • To remove a schema, click .
8. To filter the objects that are controlled with this project, expand the schema node and then refer to the following table. By default, all objects of all object types are included in the project.

9. Click OK.
10. (Optional) Create additional Team Projects.
11. Click Apply to direct SQL Navigator to create the Team Project(s) and the associated projects in the VCS, if applicable. The objects are added to Team Coding, but not to the VCS.

Team Coding Roles

Team Coding only has one defined role, that of the Team Coding Administrator: TC_ADMIN_ROLE. This role is automatically granted to the user who creates the Team Coding objects. This user can set up or remove Team Coding, set up global rules for the Team Coding environment, and set up Team Projects.

If necessary, you can grant the TC_ADMIN_ROLE to additional users. Be sure to select the Default checkbox when you grant the role to additional users.

You do not need to assign a role to other Team Coding users. By default, all users in the database can:

• View the status of objects with the Team Coding Viewer
• Lock and unlock database objects
• Check items in and out of source control (if a VCS is in use)
• Mirror their schema to a Team Project

Administer Team Coding

Configure Team Coding

Use the Configure Team Coding Options page to configure the following local settings that are unique to your local SQL Navigator installation:

• (Optional) Configure connection to a version control system (VCS). See Version Control Systems.
• Configure code check-in and logging options. See also View | Preferences| Team Coding.

To set local Team Coding options

• From the Main Menu, click Team Coding | Configure.

  

Options