Forum Discussion
Copy Job from on prem SQL to Fabric SQL Database Error
Hi there Fabric Experts. I am trying to copy data(using Copyjob) from SQL on prem to fabric SQL database. My connection works just fine and I can connect to the datasource,view the tables, select...
Hi aadhilkhan ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you lbendlin for the prompt response.
This is a known limitation with Copy Job --> Fabric SQL DB, where the destination artifact may not be resolvable at runtime even though it is selectable in the UI. As suggested, using Mirroring is the recommended alternative for on-prem SQL sources, as it reliably syncs data into Fabric without Copy Job resolution issues. Mirroring continuously replicates data and does not overwrite translytical changes made in Fabric SQL tables.
Here are few Microsoft Documentations that will help:
Mirroring - Microsoft Fabric | Microsoft Learn
What is Copy job in Data Factory - Microsoft Fabric | Microsoft Learn