Defining the database object changes for the change management script

In the Change Management Script Editor, you can define the changes that you want to make to your database objects.

About this task

To define database object changes, complete the following steps:

Procedure

  1. Populate the Objects to be Changed list in Working with Objects section with the objects that you want to create, alter, or drop.

    You can use either of the following methods to add objects to create, alter, or drop to the Objects to be Changed list:

    • Click the Add Objects button in the Objects to be Changed list in the Working with Objects section. Complete the steps in the Add Objects wizard to select the objects to add.
    • In the Administration Explorer, drill down to and expand the database that is associated with the change management script. For an object that you want to alter or drop, click the folder for that object type. In the Object List view, find the object that you want to alter or drop. Right-click the object and click Alter or Drop. You can select multiple objects.

    In the workbench editor area, focus shifts to the Change Management Script Editor.

  2. To change the attributes of an object that you are creating or altering, select the object in the Objects to be Changed list. Then, go to the Properties view, which by default is located below the Change Management Script Editor, and use the tabs to find and alter the object's attributes.
    Tip: As you add objects to the Object to be Changed list and use the Properties view to alter object properties, you can use the undo and redo feature to remove or add back the changes that you make.
  3. Assess the other objects that might be affected by changing the objects.
    1. In the Objects to be Changed list, click each object. Any other objects that are affected by the object that is being changed are displayed in the Impacted Objects list.
    2. Include impacted objects in the change management script. Use the Alter and Drop buttons to move the impacted objects to the Objects to be Changed list. If you use the Alter button to move an impacted object, click the object and make any necessary changes to that object in the Properties view.

What to do next

You are ready to generate the change commands that will implement the changes that you defined.

Tip: Other techniques exist to define database changes. When you migrate data from one table to another or migrate changes from one database to another, the list of Objects to be Changed is automatically populated.

Feedback