The requirements are that certain tables with primary and foreign keys are cloned from PROD to TEST Environment weekly.
I thought about using Logic Apps, Foreign Tables with merging or Azure Data Factory.
What would be the best way to do this?
The requirements are that certain tables with primary and foreign keys are cloned from PROD to TEST Environment weekly.
I thought about using Logic Apps, Foreign Tables with merging or Azure Data Factory.
What would be the best way to do this?