Share via

How can I export bacpac from one Azure SQL DB and import it on another Azure SQL DB in Data factory ?

OGINTZ Marina 175 Reputation points
2024-01-22T08:42:59.55+00:00

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?

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,639 questions
SQL Server | Other
Accepted answer
  1. Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator
    2024-01-22T08:59:59.7966667+00:00

    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

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.