You can create a change management script to help you manage
changes to your database objects and run those changes against your
target database.
Before you begin
The Database Change Management feature of
Optim™ Database
Administrator must
be installed, and change management capability must be enabled.
About this task
Change management scripts can be explicitly created, or they
are automatically created when you initiate a change directly from
the
Administration Explorer or the
Object
List.
Procedure
To explicitly create a change management script, complete
the following step:
In the Administration Explorer,
right-click the Change Management Scripts folder
of the database that you want to change, and click New
Database Change. A change management
script is created and automatically named. By default, the name of
the script is the name of the database connection. If more than one
change management script exists for that database, the name is the
name of the database connection with a numeric suffix.
Remember: The following steps to create, alter, or drop objects
from the
Administration Explorer or
Object
List would automatically create a change management script:
- To create a new object, in the Administration Explorer,
right-click the folder that contains the type of object to create,
and click . Depending on the object that you are creating, you
might be specified to specify a schema, table, or view in which to
create the object. If you are prompted to specify which editor you
want to use, select Change Management Script Editor.
- To alter or drop an existing object, in the Administration
Explorer, right-click the folder that contains the type
of object to alter or drop. In the Object List view,
find and select the object that you want to alter or drop (you can
select multiple objects). Right-click, and click Alter or Drop.
If you are prompted to specify which editor you want to use, select Change
Management Script Editor.
What to do next
The Change Management Script Editor opens.
You can now use the functions in the Change Management Script
Editor to define the changes that you want to make to your
database objects, generate the corresponding change commands, and
run them.