Azure DevOps and Redgate Tools

JohnSterrett

Hi Everyone,

I thought I would start my RedGate Friends Program with a very basic question. I am sure someone can point me in the right direction. I apologize if this is not the right place for this post.

Can anyone point me towards some resources for going from start to finish of a very basic SQL repository in DevOps (Azure TFS in the cloud) with automating CI? Would love to do it with and without using Azure for SQL too. For example, would like to still use Azure DevOps but be able to automate deployments into my local environment outside of the cloud. 

Obvious would love to do this via RedGate tools as well as I am sure it would make things a lot easier.

Regards,
John

Mac_F

Hi John,

Have you tried our Redgate University site yet? It has a lot of great videos that give instruction on Redgate products. This particular series of videos really helped me understand and setup an automation CI on my own Azure DevOps using local DB's instead of the cloud.
https://www.red-gate.com/hub/university/sql-change-automation-with-sql-source-control-projects

Also, here are a couple of other articles that I think may help you.
https://www.red-gate.com/hub/product-learning/?topic=continuous-integration

Regards,
Mac

chris_godfree

Hi John - I'm doing this right now because we're migrating to Azure DevOps from TFS on premises so can assure you that it does work and is pretty straightforward! Local Dev database -> Azure DevOps repo using SQL Source Control -> Azure DevOps Build/Release pipelines using SQL Change Automation extensions -> local Test database.

JohnSterrett

Thank you, Chris and Mac. I think I am getting hung up on the Pipeline for deployment and also the agent required for pulling and deploying locally.

chris_godfree

 We use Windows self-hosted agents: https://docs.microsoft.com/en-us/azure/devops/pipelines/agents/v2-windows?view=azdevops.

Have you installed the two SQL Change Automation extensions from the marketplace - they're needed for the pipelines (unless you build your own bespoke ones using the Powershell cmdlets): https://marketplace.visualstudio.com/search?term=redgate&target=AzureDevOps&category=All%20categories&sortBy=Relevance