Hey, Based on my knowledge, ADF doesnt have the out of the box feature to achieve this. You would have to integrate ADF with some other offerings like Azure automation/Azure function etc to achieve the same (maybe via powershell) Not sure whether the below would work, you need to test it out yourself : Levereage web activity to trigger the REST APIs for export and import: https://learn.microsoft.com/en-us/rest/api/sql/databases/export?view=rest-sql-2021-11-01&tabs=HTTP https://learn.microsoft.com/en-us/rest/api/sql/databases/import?view=rest-sql-2021-11-01&tabs=HTTP
How can I export bacpac from one Azure SQL DB and import it on another Azure SQL DB in Data factory ?
OGINTZ Marina
105
Reputation points
Hi, I would like to preform export from one DB and to import it to another one. It should be only with data factory. Can please someone assist me with this?