Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.
If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!
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
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login