Trying to execute scripts via the pipeline using RedGate tasks

mkumar · January 16, 2020 3:32PM

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?

Sergio R · January 17, 2020 5:01PM

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.

Sergio R · January 17, 2020 4:18PM

The release logs will indicate whether the release was successful or not.

mkumar · January 17, 2020 4:23PM

Sergio R said:

The release logs will indicate whether the release was successful or not.

Hey, thanks for the reply. I am basically trying to execute/deploy scripts from a custom folder on TFS to the database via RedGate. For that operation, does the schema changes take part? Will that cause an issue and would the database be dropped?

mkumar · January 17, 2020 5:07PM

Sergio R said:

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.

Can I deploy/execute data scripts from a source control (with a custom folder in it) to the database via RedGate Tasks on TFS 2018 without using Visual Studio or SSMS? Assuming I know the target database, SQL Server credentials...

Sergio R · January 22, 2020 9:56AM

If you mean a scrips folder created with SQL Source Control with occasional migrations (Custom Scripts), then yes, the TFS SQL Change Automation task will be able to deploy that.

Please see (note that the Azure DevOps task is identical to the TFS task):
https://documentation.red-gate.com/sca/deploying-database-changes/add-ons/azure-devops/use-the-azure-devops-build-extension-with-sql-source-control-project

https://documentation.red-gate.com/sca/deploying-database-changes/add-ons/azure-devops/use-the-azure-devops-release-extension

https://documentation.red-gate.com/sca/deploying-database-changes/add-ons/azure-devops/use-the-azure-devops-release-extension-with-an-approval-step

Trying to execute scripts via the pipeline using RedGate tasks

Best Answer

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk