Description

Roles

Attributes

Steps

1. Execute Build Script Against Target Server:
   Execute the build script against the target server in the T-SQL editor.
   
   Analyze any failures that occur.

2. 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.

3. Resolve Deployment Work Item:
   Resolve the deployment task.

Inputs and Outputs

WorkProduct	Input	Output	Allowable States
Task			(none)

Predecessors

Type	Name	Dependency Type
	Back Up Target Database	Finish-Start
	Deploy Database to Staging Server	Finish-Start