Running a change management script

Run your change management script to apply the changes that you make with the Change Management Script Editor to your database.

Before you begin

You must use the Change Management Script Editor to specify the changes that you want to make to your database before you can run a script to apply those changes.

Procedure

To run the script that applies changes to your database, complete the following steps:

  1. If your change management script is not already open in the Change Management Script Editor, complete the following steps to open it:
    1. In the Administration Explorer, drill down to the database to be changed and expand its contents. Expand the Change Management Scripts folder.
    2. Double-click the change management script that you want to open. Change management scripts have file names that end with .changexml.
  2. Generate your change commands by clicking Preview commands at the top of the Change Management Script Editor. You might have to scroll to the top of the Change Management Script Editor. After the Change Management Script Editor has generated the commands that make the changes that you specify, the editor opens the Commands section.
  3. Click Run to start the Run Change Commands wizard.
  4. On the Change Commands page of the Run Change Commands wizard, review the commands that the Change Management Script Editor will run. If the commands have an error or are otherwise unsatisfactory, you can specify your changes again and regenerate the change commands.
  5. Click Finish to apply the changes to your database. The Messages section displays status about the commands as they are running and records the final state of running the change script. You can also use the SQL Results view to see the status of each command.
    Tip: If a command does not run successfully, you can click the message number or SQL code that is displayed in the Messages section to get more details. The link for the message or SQL code opens an information center with the detailed information.

Results

After the deployment process is completed, a Deployment report is automatically generated. This report lists the commands that were run and the status of running them. The report is stored in the Other Files folder in the same project as your change management script.

Your database now reflects the changes that you specified.


Feedback