When the first change plan is created for a database, a Data Design Project is created automatically. The name of the project is database_connection-name Change Plans, where database_connection-name is the name of the database connection. For each change plan that is created for the database, the project contains the resources, including models and scripts, that are needed to make the database changes in that change plan.
Type of script | File extension | Description |
---|---|---|
Do scripts | sql | Contains the set of commands and statements
that were run against the database. The file is created when you click Run and
then Finish in the Review and Deploy dialog. The file name for a do script is: change_plan_name timestamp_Change |
Undo scripts | sql | Contains the set of commands and statements
that can be used to rollback the changes that were made by deploying
the change plan. The file is created when you click Run and
then Finish in the Review and Deploy dialog. The file name for an undo script is: change_plan_name timestamp_Change_Undo |
You can use the Team features of Eclipse to store and retrieve projects and project resources in a library control system so that multiple users can share the resources and use version control.