Deployment pipeline limitations about mirroring

[pmscorca]

Hi,

I need to implement a SQL Server mirroring and I'd like to know if there are any limitations for deployment pipelines in order to deploy a such feature between environments.

I've read that the related SQL analytics endpoint cannot be deployed by a deployment pipeline yet.

Many thanks

[v-karpurapud]

Hi @pmscorca 
Thank you for contacting the Microsoft Fabric community forum.
 

Currently, Microsoft Fabric deployment pipelines do not support deploying SQL Analytics Endpoint objects, such as tables, views, or stored procedures. Both users identified this correctly. As @Murtaza_Ghafoor noted, other Fabric items including Lakehouses, Notebooks, Dataflows, Pipelines, Semantic Models, and Reports can be deployed through pipelines without any issues. SQL Server mirroring is managed outside of Fabric and remains unaffected.
 
For SQL objects within the Analytics Endpoint, it is recommended to store scripts in Git and automate deployment using DevOps or similar tools until native support becomes available, as @tayloramy highlighted.

You can stay updated on changes and roadmap information by checking the official Fabric documentation and release notes.

What's New? - Microsoft Fabric | Microsoft Learn

I hope this information is helpful. If you have any further questions, please let us know. we can assist you further.

Best Regards.
 

[pmscorca]

Hi,

I hope that the deployment pipelines can be improved as soon as possible avoiding to use DevOps or Git.

Thanks

[Murtaza_Ghafoor · Accepted solution]

1-Fabric Deployment Pipelines do not support deploying SQL Analytics Endpoint objects (tables, views, stored procedures).

2-SQL Server Mirroring is configured outside Fabric, so it is not affected by deployment pipelines.

You can still deploy Lakehouses, Notebooks, Dataflows, Pipelines, Semantic Models, and Reports using deployment pipelines.

Any SQL objects needed in the analytics endpoint must be deployed manually or through Git + DevOps.

Best practice: store SQL scripts in Git and automate their execution separately during environment promotion.

[pmscorca]

Hi, it would be preferable the full compatibility with the deployment pipeline.

[tayloramy]

Hi @pmscorca, 

The microsoft docs explicitly call out that this is compatible with Git and with deployment pipelines: 
https://learn.microsoft.com/en-us/fabric/mirroring/mirrored-database-cicd

 It should work. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[pmscorca]

Hi, thanks for your reply.

I'd like because there isn't the full compatibility between the mirroring and the deployment pipeline and when it will be implemented and released.

Thanks