topic Re: Deployment pipeline limitations about mirroring in Mirroring

Deployment pipeline limitations about mirroring

pmscorca — Wed, 03 Dec 2025 18:17:52 GMT

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

Re: Deployment pipeline limitations about mirroring

tayloramy — Wed, 03 Dec 2025 21:13:20 GMT

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.

Re: Deployment pipeline limitations about mirroring

pmscorca — Thu, 04 Dec 2025 08:26:32 GMT

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

Re: Deployment pipeline limitations about mirroring

Murtaza_Ghafoor — Sun, 07 Dec 2025 06:58:08 GMT

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.

Re: Deployment pipeline limitations about mirroring

pmscorca — Mon, 08 Dec 2025 16:17:20 GMT

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

Re: Deployment pipeline limitations about mirroring

v-karpurapud — Wed, 10 Dec 2025 11:00:33 GMT

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.

Re: Deployment pipeline limitations about mirroring

pmscorca — Wed, 10 Dec 2025 15:28:22 GMT

Hi,

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

Thanks