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.
Super UserHi 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.
pmscorcaHi, 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