Activity Information Deploy Database
DescriptionNow you are ready to do the deployment to target server. This can be done by executing the build scripts against the target server and then verifying the results. Attributes| Element Categories | [CMMI Track 5] Deploy, [CMMI Level 3] PI SP 3.3, [CMMI Level 3] PI SP 3.4 | | Entry Criteria | Build Script Created:
The build script is generated and modified appropriately.
Target Database Backed Up:
The target database for the database project deployment is backed up. | | Exit Criteria | Database Project Deployed:
Database project changes are successfully deployed to the target server. | | Is Required | Yes |
StepsExecute Build Script Against Target Server:
Execute the build script against the target server in the T-SQL editor.
Analyze any failures that occur. Use Schema Compare to Verify Deployment:
Create schema comparison sessions to view the differences between the project and the target server.
Ensure no unknown differences exist between the two databases. Known differences include objects that are defined in pre-deployment or post-deployment scripts, because these objects will not appear as part of the schema comparison. Rules and defaults are examples of such objects. Resolve Work Item:
Resolve the deployment task.
Inputs and Outputs| WorkProduct | Input | Output | Allowable States |
|---|
| Task |  | | (none) |
|
Last modified at 12/19/2007 10:37 AM by Administrator
|
|