topic Re: Copy Data Assistant - From Fabric SQL DB to Fabric SQL DB in another workspace - FAILs in SQL database

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

PeterDaniels — Mon, 27 Jan 2025 22:44:59 GMT

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?

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

dlevy — Tue, 28 Jan 2025 17:25:10 GMT

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

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

PeterDaniels — Wed, 05 Feb 2025 20:38:30 GMT

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