Forum Discussion
Copy data for on-prem SQL server
Hi, does anyone have an idea of when the "Copy data" activity might work for on-prem data sources (in our case SQL Server)? I know we can use Gen2 dataflows for this - but they are very slow. Really ...
Datamarts are you friend here - it sounds odd but they are a great tool in the Fabric toolbox
Create a Datamart and load you data from your on prem SQL server to the Datamart
Then in a pipeline use a copy activity to move the data from the datamart ( which appears as an Azure SQL Server) to the target Warehouse.
It works really well and we use it estensively as Gen2 Dataflows do not have the reliability or performance that we need.
你好，请问数据仓库从datamarts复制数据的具体配置是什么样的呢