Online Documentation for SQL Manager for DB2

Change management


This set of tools allows you to store changes in metadata, remember database structure state, compare database states in different time points and view history of database changes.

 

Version control system (VCS) is a mean that 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.

 

This section can be inactive if version control is disabled for the database. To enable version control use the corresponding section of the Database Registration Info dialog.

 

SQL Manager for DB2 provides the following Change management tools:

 

Create tag wizard

Remembers current database state.

 

Check repository wizard

Reveals and fixes differences between database state and it's description in repository.

 

Get change script wizard

Generates script that reflects differences between two database states.