Azure DevOps and Redgate Tools

• 
  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
  

  Mac_F January 24, 2019 00:05

  - 0 +
• 
  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.
  

  chris_godfree January 24, 2019 14:28

  - 0 +
• 
  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.

  JohnSterrett January 24, 2019 17:28

  - 0 +
• 

   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
  

  chris_godfree January 28, 2019 13:14

  - 0 +

Add comment

Please sign in to leave a comment.