Azure Data Factory DB Refresh
Budget: $25 – $50 USD
I need an end-to-end Azure Data Factory solution that refreshes our lower-environment SQL Server databases directly from the latest backup files stored on an Azure File Share. The pipeline should detect the newest .bak, copy it into the target resource group if needed, drop or overwrite the existing dev/test databases, and restore them without any data transformation.
Please build the pipeline, linked services, datasets, and any required integration runtime settings, then export everything as an ARM/JSON template so I can deploy it through Azure DevOps. Documentation must cover authentication to the file share, parameterisation for database names and restore paths, and a simple way for me to adjust the schedule (I will finalise the cadence once the core workflow is in place).
The deliverables are:
• Azure Data Factory pipeline JSON (ready to import)
• Supporting assets (linked services, datasets, triggers)
• Step-by-step deployment and rollback guide
Success means I can deploy the template, run the trigger, and watch our dev and test SQL Server databases refresh from the file share backup with no manual intervention.
Please build the pipeline, linked services, datasets, and any required integration runtime settings, then export everything as an ARM/JSON template so I can deploy it through Azure DevOps. Documentation must cover authentication to the file share, parameterisation for database names and restore paths, and a simple way for me to adjust the schedule (I will finalise the cadence once the core workflow is in place).
The deliverables are:
• Azure Data Factory pipeline JSON (ready to import)
• Supporting assets (linked services, datasets, triggers)
• Step-by-step deployment and rollback guide
Success means I can deploy the template, run the trigger, and watch our dev and test SQL Server databases refresh from the file share backup with no manual intervention.