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
- 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.
- 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.
- Assess the other objects that might be affected
by changing the objects.
- 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.
- 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.