Merging change commands

If you make additional changes to your DDL after you have generated your change commands, you have the option to merge these changes. DB2® Change Management Expert will detect additional changes and prompt you to merge them by using the Merge Editor.
If you have already generated your change commands, and make an additional change, you must use the Merge Editor to merge those changes into one change command script. For example, if you add a GRANT statement to your existing DDL script by using the Change Command Editor and then generate change commands, DB2 Change Management Expert will prompt you to merge your changes.
To merge your change commands, complete the following steps:
  1. After you have made one change to the target model, on the Change Commands tab of the Deployment Script Editor, click Generate Change Commands. Your new change commands script will appear under the SQL Scripts folder in the Data Project Explorer view.
  2. If you make an additional change to your target model, you will not lose that change. For example, if you added another statement to the change command script or added a column to your target model. When you generate your change commands again, you will be prompted to merge your changes.
  3. On the Change Commands tab of the Deployment Script Editor, click Generate Change Commands. DB2 Change Management Expert will prompt you with a message asking you if you want to merge your changes. Click Yes to display the Merge Editor.
  4. In the Merge Editor, select the additional change from the Calculated Change Commands side of the editor and click the left arrow button to move your change to the Existing Change Commands side of the editor. Click OK to merge your changes.
You have now successfully merged your changes into one change command script.


Feedback

Copyright IBM Corporation 2006, 2007. All Rights Reserved.