Trying to execute scripts via the pipeline using RedGate tasks

I have a script on my source control and trying to execute via RedGate SQL Change Automation Task on the pipeline. The release was a success. What would the next step be? How do I  check the script I executed is done? Where can I see the output? I do not have access to the visual studio- database. There is a separate team for that. My role is just to help put the database stuff on the CICD practice... Is there a way I can verify my work?

Best Answer

  • Sergio RSergio R Posts: 550 Rose Gold 5
    Accepted Answer
    Assuming you are using the Release task, it won't drop the target database.
    The Build task uses a temporary database that will be cleaned beforehand and depending on your settings can be a dynamic database that's created at the start of the build and dropped when it finishes.
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools


Sign In or Register to comment.