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
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
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,450 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,222 questions
{count} votes

Accepted answer
  1. Nandan Hegde 34,021 Reputation points MVP
    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

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.