Unable to Select Mirror Database as Source in Copy Activity

[Jaganath]

Hi Team,

I am using Azure SQL Database as the source to ingest data and process it through different layers (Medallion architecture) in Fabric. I have utilized the Mirror Database option to mirror the Azure SQL Database into Fabric and am considering the mirrored database as my Bronze layer.

However, I am unable to select the mirrored database as a source in the Copy Activity. Is this a known limitation?

Thanks,

Jaganath

[v-jingzhan-msft · Accepted solution]

Hi @Jaganath 

I tried but didn't see the mirrored database as an option in the data source. In addition, Mirrored database isn't listed in the document: Data pipeline connectors in Microsoft Fabric. So I think it is not a supported data source for Copy data activity. You may raise an idea at Fabric Ideas Forum

Since Azure SQL Database is a supported data source for Copy activity, you can ingest data from Azure SQL database directly. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[Jaganath]

Hi Team,

I am using Azure SQL Database as the source to ingest data and process it through different layers (Medallion architecture) in Fabric. I have utilized the Mirror Database option to mirror the Azure SQL Database into Fabric and am considering the mirrored database as my Bronze layer.

However, I am unable to select the mirrored database as a source in the Copy Activity. Is this a known limitation?

Thanks,

Jaganath