Forum Discussion
Post ProdigyDeployment pipeline limitations about mirroring
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.
Community SupportHi 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.
pmscorcaHi,
I hope that the deployment pipelines can be improved as soon as possible avoiding to use DevOps or Git.
Thanks