Deploy a Database Project

Database Administrator

1

Synchronize Database Project

• Review assigned deployment task.
• Synchronize database project to desired version.

2

Verify Build

• Build database project.
• Deploy database project to sandbox server.

3

Perform Database Unit Tests

• Perform database unit tests.
• Analyze test results.

4

Analyze Changes

• Review source control change history since last deployment.
• Use schema compare to analyze differences between the project and the target server.
• Review the refactoring log files.

5

Create Build Script

• Set the appropriate build target connection and related build properties.
• Build database project.
• Modify build script.

6

Back Up Target Database

• Back up target database.

7

Deploy Database to Staging Server

• Optional
• Execute build script against staging server.
• Use schema compare to verify deployment.

8

Deploy Database

• Execute build script against target server.
• Use schema compare to verify deployment.
• Resolve deployment work item

Database project changes are successfully deployed to the target server.