1

Set the Appropriate Build Target Connection and Related Build Properties

• Configure the database project settings appropriately to specify the target connection and associated build properties.

2

Build Database Project

• Build the database project.
• Review and fix any build errors identified. The type of build errors mentioned here are environmental errors.

3

Modify Build Script

• Review the build script to ensure it performs the actions you expected in order to synchronize the source project with the target.
• If data motion must occur, modify the build script to appropriately incorporate data motion. While the default build script will not result in data loss, it will not appropriate migrate data when necessary.

The build script is created and appropriately modified for the target server and production environment.