Forum Discussion

MOVC's avatar
MOVC
Icon for Resolver I rankResolver I
2 years ago
Solved

On Prem SQL Server to Fabric Warehouse via Copy Data

I've been testing the Copy Data activity from On Prem SQL server via a Data Gateway which was recently made available. I have successfully managed to load into a Lakehouse, but when trying to get Dat...
General Question
pipelines
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi MOVC , Joshrodgers123 , ShaunBrewer 

    Internal Team confimed that, it is on the roadmap. At present we don't have any ETA. But we can expect this feature in future.

jagdishwagh0909's avatar
jagdishwagh0909
Icon for Helper I rankHelper I
1 year ago

Currently, it is not possible to directly copy data from an on-premises SQL Server (via the gateway) to a Fabric Warehouse. The recommended workaround is to first copy data from SQL Server to a Lakehouse (copy actiovity 1)and then move it from the Lakehouse to the Warehouse (Copy Activity 2). However, this is not an optimal solution, especially for small datasets, as it introduces unnecessary complexity and inefficiency.

We request the Fabric team to address this issue as soon as possible. Delaying this feature may lead to significant rework in the future if direct data transfer from SQL Server to the Warehouse is eventually enabled.