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:
- If your change management script is not already open in
the Change Management Script Editor, complete
the following steps to open it:
- In the Administration Explorer,
drill down to the database to be changed and expand its contents.
Expand the Change Management Scripts folder.
- Double-click the change management script that you want
to open. Change management scripts have file names that
end with .changexml.
- 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.
- Click Run to start the Run
Change Commands wizard.
- 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.
- 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.