1

Execute Build Script Against Staging Server

• Optional
• Execute the build script against the staging server in the T-SQL editor to ensure that the deployment will succeed on this server prior to deployment to the target server.
• Analyze any failures that occur.

2

Use Schema Compare to Verify Deployment

• Optional
• Create schema comparison sessions to view the differences between the project and the staging 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.

The database is deployed to a staging server and verified.