Hi, I've recently migrated from On Prem to PaaS and I has previously created an automated DB refresh from PROD to UAT (PROD to TST, PROD to DEV etc)
However prior to refresh i would capture the UAT settings into a new table then remove the Prod data in the restored DB and then insert the captured data. All very simple when able to use cross server queries etc.
I'm trying to create this process but am not sure as i rename the existing database to DBName_original and restore the prod DB as DBName. So aim would be data all from DBName_Original across.
Is there any way? I think Data factory can be used and i think that's the only way but my Azure exposure isn't that great. Just hoping to avoid having a complex process.
EDIT: accidentally created in Azure Development section, should really be in Azure Administration. MOD to move if possible.