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.

Database project changes are successfully deployed to the target server.