I'm building a POC for DB devops using redgate SCA and an azure devops pipeline. Need to connect to our SQL Servers that don't have public IPs. Was hoping power BI on-prem gateway would facilitate. Is there a way to make that work, or do I need local build agents?
To clarify, I have :
- Azure devops (cloud) on org.VisualStudio.Com
- RedGate SQL Change Automation project in: TFSVC based repo (in azure devops services in org.VisualStudio.Com
- Integration DB on SQL Server instance in company network - no public IP.
I now have a azure devops build pipeline triggered by source commit. The SCA build artifact is created and stored. I want to deploy to our integration SQL Server DB.
At this point, I believe I need to install and configure a local windows build agent to enlist in the pipeline. It seems unfortunate, though, since we already have power BI on-premises data gateway. It would be nice to leverage that connectivity in our deployment pipeline instead of having to configure a local build agent.
It's also unfortunate because I'm finding the online docs for configuring a local build agent to be challenging and unclear.
Can you help me get over this hurdle?