Running DB Scripts

We have an 'Execute Database Scripts' Action which picks up all scripts in the source folder with a search filter of '*.sql'.

This all works fine apart from the log claims to run each script everytime (which is the behaviour we want) but, in fact, it seems each script is run once and only once!

No matter how many time the deployment occurs, a script never seems to run again - regardless of what the log says.

Could you please confirm the expected behaviour here and how we can get our desired functionality?

Thanks.

PS. This is affecting a large project which is already in production and is relying on Build Master to simplify all aspects of deployments inclusing DB scripts.

The "Execute Database Scripts" action executes all the scripts in the specified source directory (and all subdirectories of that directory) on every execution. The only scripts that are run once and only once are the Change Scripts via the "Execute Database Change Scripts" action.

Can you verify that:

the action is referencing the correct provider and instance
the action is running the correct server
if applicable, previous actions are putting the .sql files in the correct source path on the correct server
the source directory of the "Execute Database Scripts" action has the files you expect in it