How is SQL Change Automation helping you? Share to win DevOps books.

Azure DevOps SQL Change Automation: Build error

Hello,

I have followed this guide to try to create an automated build pipeline in azure devops and using the provided project.

https://documentation.red-gate.com/sca3/automating-database-changes/add-ons/visual-studio-team-services/use-the-vsts-build-extension-with-sql-change-automation-project



however, when I go to actually try to run the release with the defaults, it gives me this,




If anyone else has ran into this issue before, or might have some ideas at what the problem could be, please send it.

Thanks,

Answers

  • Did you click the ellipsis to the right of the SQL Change Automation Project field?

    Setting the system.debug variable to True will increase the verboseness of the log and give you a better indication why this is failing
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
  • joemo65joemo65 Posts: 2 New member
    I figured out my issue and it was just a dumb mistake on my part. I was attempting to do the Build step in a release pipeline instead of a build pipeline.

    The reason that lead me to doing this was because in the first step when selecting where is your code I would select "Azure Repos" which then would not allow me to select an empty Pipeline project template later on and thus not being able to select the Change Automation Build Tool.



    I recommend making sure to "use the visual designer" and then selecting your repository otherwise you may have trouble trying to create an empty pipeline template and thus not be able to select the extension.
Sign In or Register to comment.