Team coding and Version Control support

 

 

SQL Navigator provides extensive and flexible Team Coding controls, including integration with third-party version control systems.

The SQL Navigator Team Coding module—

image\Sqln0004.gif provides PL/SQL Developers with the ability to develop stored programs (Procedures, Functions, Packages, Triggers and Views) in a co-operative manner.

image\Sqln0004.gif prevents multiple SQL Navigator users modifying the same objects concurrently through a check in/check out mechanism.

These features are available to all users, whether or not they are using a third-party version control product

SQL Navigator also works with a third-party version control product to maintain revision histories. This happens automatically in the background, so you dont have to leave SQL Navigator to update your version control revision histories.

Team Coding menu and toolbar

image\Sqln0077.gif image\Sqln0078.gif

 

Viewing the status of objects under Team Coding control

The Team Coding Viewer shows details of objects under Team Coding control, including which objects are currently checked out and when they were last checked in. Checked-out objects are flagged.

You can check out or check in objects directly from this window, and (with appropriate privileges) you can also freeze objects so that they cannot be modified by other users. As shown below, you can view details of any object in the list.

Viewing object details in the Team Coding Viewer

image\Sqln0195.gif

Reviewing the Version Control archives

You can view all version control archives in all projects using the SQL Navigator Version Control Browser. As shown below, you can view differences between revisions. You can also check out objects and scripts using the Version Control Browser.

(This browser is not available to users of SCC API Team Coding support; instead, selecting this option launches the user interface of the third-party product in use.)

Preparing to compare versions from the Version Control Browser

image\Sqln0196.gif