Data Design Projects

A Data Design Project is a container for storing the resources that you use to plan, analyze, archive, and make changes to your databases. Projects are displayed in the Data Project Explorer view, and they correspond to directories in the file system.

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.

The resources that you use to make database changes include models and scripts. When a project is created, the following virtual subfolders are displayed within the project to organize the following resources:
Data Diagrams folder
Holds files that are for the product's internal use only.
Data Models folder
Holds models that are for the product's internal use only. Models have a file extension of .dbm.
Other Files folder
Holds the files that do not belong in either the SQL Scripts or Data Models folders. For example, the deployment log files with a .log file extension and the report .html files are placed in this folder.
SQL Scripts folder
Holds the types of script files that are shown in the following table:
Table 1. Types of scripts in the SQL scripts folder
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:
  • project_name_Change_Do_timestamp
  • project_name_Change_Undo_timestamp
  • project_name_Change_Restart_timestamp
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:
  • project_name_Change_Edited_Do_timestamp
  • project_name_Change_Edited_Undo_timestamp
SQL script

sql
ddl

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.


Feedback