To perform automation or scheduling process to copy / transform data, Azure automation (runbook) or Azure data factory or Azure Logic Apps services can be used.
Not really sue if Azure DevOps Build / Release pipeline is good for this.
You may ask ADO experts in below dedicated forum
https://developercommunity.visualstudio.com/spaces/21/index.html
Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav