What are the challenges you face when working across database platforms? Take the survey

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

  • Options
    Sergio RSergio R Posts: 610 Rose Gold 5
    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.