Creating a change management script

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 ofOptim™ 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 Create > New DatabaseObject. 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.


Feedback