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?
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.