Trying to execute scripts via the pipeline using RedGate tasks

mkumar

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

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

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

mkumar

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

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

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