Online Documentation for SQL Manager for DB2

Change management


The Change Management section of the Database Registration Info dialog allows you to define settings required for working with version control systems.

 

Version control system (VCS) enables teamwork under a project.

 

This system can be useful for single developers, whose databases have complex business logic in procedures, triggers etc. VCS provides change management means to control changes of objects.

 

What can you get from VCS in SQL Manager for DB2:

 

For database developers:

  • Control of changes in database;
  • Getting (storing, testing) change scripts that reveal differences between two database states;
  • Possibility to rollback database to definite state;

For database administrators:

  • Control of changes in database

 

CheckBox Enabled

Use this option to enable/disable change management feature for the database.

 

Database Registration Info - Setting change management parameters

 

 

Click the corresponding button to launch the Repository management wizard. It allows you to create/check out repository.

 

Version control provider

 

Source provider

Use the drop-down list to select version control provider.

The following versions of VCS providers are supported:

  • CVS (version 1.9 or higher)
  • Visual SourceSafe (version 8.0)
  • Team Foundation Server (2005)

 

Each version control system requires client program be installed.

 

Specify User Name and Password to be used to authorize to version control repository.

 

Press the Properties... button to view/edit or test VCS provider settings:

 

Change Management - VCS Properties

 

 

Settings description you can find in the following topics:

 

Location

 

Version control project

Defines version control project location.

 

Working folder

Use this field to define location of version control system project. Make sure that path format conforms the selected VCS standard.

 

Branch name

Indicates current branch name. The branch name is always trunk and can't be modified.

 

Press the OK button to check connect to the Version Control server and to apply settings.