Schema Compare and Deployment Scripts

Question

I have a VS2012 database project and am using schema compare to release from the development to the live database.

I had assumed that the pre-deployment and post-deployment scripts would be executed before and after the schema compare update script. But it seems these scripts are never executed as part of a schema compare.

Is this by design or is there a setting somewhere I have missed?

Answer 1

When you are comparing schemas you are not actually deploying the database, so the pre- and post-deployment scripts won't run.

You have to select Deploy from Build menu for this scripts to run.