When you create a change management script, a Data Design Project is created automatically. The name of the project is the name of the database connection. If a project with the name of the database connection exists, the name of the new data design project is the database connection name with a numeric suffix. The project contains the resources, including models and scripts that are needed to make your database changes.
Type of script | File extension | Description |
---|---|---|
Change management script | changexml | Contains a set of changes to make to a database. The change management script brings together the specification resources (models), change commands, undo commands, and metadata about the change and organizes them into a coherent form. |
Do, undo, and restart scripts | sql | Contains a set of changes to make to a database.
Every time change commands are generated or run, do and undo scripts
are saved as read-only files. You can use these files to undo changes
if you later decide to undo the change that you deployed. A read-only restart script is saved if the change commands do not run successfully. The restart script contains the commands that have not been run. When additional failures occur, multiple restart scripts are created. The
file names for the files are:
|
Edit and edit undo scripts | sql | Contains change commands that have been edited
with the SQL and XQuery editor. When you click Edit or Edit
Undo in the Commands section of
the Change Management Script Editor, the edited
files are saved with the following file names:
|
SQL script | sql |
Contains SQL statements. |
The Change Management Scripts folder under the database in the Administration Explorer also contains the change management scripts for a database. You can use either the Change Management Scripts folder in the Administration Explorer or the SQL Scripts folder in the Data Project Explorer view to work with your change management scripts.
You can also create a project explicitly.