Forum Discussion

PeterDaniels's avatar
PeterDaniels
Advocate II
1 year ago

Copy Data Assistant - From Fabric SQL DB to Fabric SQL DB in another workspace - FAILs

After migrating items, including a Fabric SQL DB, from one workspace to another using deployment pipelines, I tried to use a Fabric Data Pipeline (in the new/destination workspace) Copy Data Assistant to copy the data from the source Fabric SQL DB to the new Fabric SQL DB.  Was stoked to see the table schema came across via the deployment pipeline, but when connecting to the source SQL DB, got an error:

 

Any ideas?

Need Help
sql database

2 Replies

  • dlevy's avatar
    dlevy
    Microsoft Employee
    1 year ago

    Hi PeterDaniels - It would be best to open a support case for this one so someone can dig into the error using that ActivityID.

  • PeterDaniels's avatar
    PeterDaniels
    Advocate II
    1 year ago

    Thank you. Getting some traction in the Fabric Partner Community channels.