Forum Discussion
Advocate IMirroring an Azure Synapse Datawarehouse Database to Fabric
We have an Azure Synapse dedicated SQL POOL - (DWU1000c) with multiple databases.
I am trying to mirror one of the database to Fabric using the Mirroring feature in Fabric.
I read the documentation and watched the videos and it seems that this is not currently supported.
Is this correct?
If true, will Microsoft introduce the capability to mirror Azure Synapse DB to Fabric in the future?
Hi balafbm,
Thank you for reaching out to Microsoft Fabric Community Forum.
Mirroring an Azure Synapse Analytics database to Microsoft Fabric is currently not supported.
If mirroring support for Synapse dedicated SQL pools is important to your use case, I recommend submitting your request via the Microsoft Fabric Ideas forum. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.
https://ideas.fabric.microsoft.com/ideas/search-ideas/If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu
5 Replies
Hi balafbm,
Thank you for reaching out to Microsoft Fabric Community Forum.
Mirroring an Azure Synapse Analytics database to Microsoft Fabric is currently not supported.
If mirroring support for Synapse dedicated SQL pools is important to your use case, I recommend submitting your request via the Microsoft Fabric Ideas forum. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.
https://ideas.fabric.microsoft.com/ideas/search-ideas/If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu- NandanHegde
Super User
As of today, Synapse dedicated pool mirroing into fabric is not available and I do not foresee that becoming available in near future as well.
There is a migration assistanet tool :
In case if you want mirroring aspect, then you would have to have a data pipeline or dataflow gen 2 to copy data from dedicated pool to fabric ecosystem
SrisakthiHi,
NandanHegde thanks .. My bad , Migrate(preview) feature supports for dacpac way of migrating objects.
Regards,
Srisakthi
balafbmRight now we are not in a position to migrate from Synapse to Fabric.
So wanted to explore mirroring certain tables from our DB, but that is not possible currently.
