How to copy data from Azure SQL Database to Azure Synapse?

Julaayi 1 Reputation point

Hello Experts,

I am pretty new to Azure Data Factory and struggling with a simple problem. I've done this in SSIS but now trying to implement the same in Azure Data Factory. I have a list of tables that I would like to copy the data on an incremental basis from Azure SQL Database to Azure Synapse. I've setup the Source with a single table to test it out. On the sink side, I've also setup the table so that I can at least do one table first and see how it goes. When I go to the Mapping tab, I tried two options - 1. Import Schemas and 2. New mapping. Neither of them are showing the structure of my table in Sink. In fact, it was showing something else. I went to the Sink Linked Service to test this out and it worked there but when I come back to the "Mapping" tab in "Copy Activity" it doesn't work. Please help me in resolving this and also suggest a better way of doing since I would like to do this over a number of tables.

My source table would be - dbo.Employee
My target table would be - staging.CRM_Employee (Since, I am getting it from say an Application CRM, I want to differentiate that accordingly on my target database (Azure Synapse).


Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,295 questions
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.
2,619 questions
{count} votes