I am looking to see if there would be a starting point in retrieveing backups from azure sql and restoring a specific database from a source server to a target server, but through a pipeline, as I'm not really a dba and this is for experimenting purposes, could someone guide me through what should I be looking into ?
Did anyone do anything remotely close to what I'm trying to achieve ? currently i'm looking into some powershell options, but I'd like to see if there are better ways on trying to achieve this, but still through a yaml pipeline.