Currently, I have 150 pipelines, 51 datasets, and 26 data flows in Azure Data Factory. This also includes our three Azure SQL Databases that hold the data used and consumed by ADF pipelines

Vaibhav Patil 20 Reputation points
2024-01-24T18:29:07.2966667+00:00

Currently, I have 150 pipelines, 51 datasets, and 26 data flows in Azure Data Factory. This also includes our three Azure SQL databases that hold the data used and consumed by ADF pipelines.
Can we migrate and move pipelines created in Azure Data Factory into Synapse Pipelines? We aim to have everything in the same environment, specifically the Synapse workspace environment. Is this migration possible?

Azure Database Migration service
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,400 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,941 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,609 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,085 questions
0 comments No comments
{count} votes

Accepted answer
  1. Harishga 3,580 Reputation points Microsoft Vendor
    2024-01-25T04:27:33.3133333+00:00

    Hi @Vaibhav Patil
    Welcome to Microsoft Q&A forum and thanks for reaching out.

    At this time you can migrate ADF pipelines/artifacts to Synapse workspace only by exporting the support JSON files of your ADF pipelines/artifacts and using Azure PowerShell cmdlets for Azure Synapse Analytics to create the same artifacts in Synapse workspace.

    Here is a previously answered thread where a detailed step-by step implementations was provided: Azure Data Factory V2 Arm template to Synpase Data Integration without Git

    Hope this helps. Do let us know if you any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful