Forum Discussion
ScottPowellECU
3 years agoAdvocate II
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 ...
AlexPowers
3 years agoMicrosoft Employee
Hey Scott! Saw your comment in another thread with respect to being able to support on-prem connectivity via pipelines, this is a top priority to bring to Fabric as part of the team's path to General Availability. There will be some improvements brought to Dataflows to help with ingestion (leveraging the same underlying copy activity / fast copy infrastructure of pipelines) there are still few items to resolve to get us there but if you can help the team out by voting over on Fabric ideas so they can best prioritize the necessary work: https://aka.ms/fabricideas
MisterSmith
3 years agoHelper I
Hi Alex
Do you know if the copy data activity in pipelines to on prem systems is available yet? And if not are there any timescales as to when it will be?
Thanks
Neil