We had a few incidents here replication either stopped completely after a data centre crash or had irrecoverable errors. In all cases we had to fully restore database or delete and start again.
We need the following features to help support replication and have smoother recovery from failures
- Start replication on GUI and API
- Stop replication on GUI and by API (The existing SQLDB API works here for Fabric)
- Query replication state on GUI and by API
- Resync either one table or all tables on GUI or by API.
These features would allow for recovery from issues without having to do full restores and reduce customers down time.
2 Comments
- fbcideas_migusrNew MemberStatus added:Under Review
- idrismotiwalaMicrosoft EmployeeStatus changed:Under ReviewtoPlanned
bob_duffy we do plan to enable Start & Stop replication in the next release cycle. Ability to configure select/specific custom tables is backlogged and be enabled at a later phase.
Recent ideas
Allow to use service principal for VNet data gateway connection to SQL Server
Service principal authentication is not supported for Azure SQL server connections when using an on-premises data gateway or a virtual network (VNet) data gateway. As a result we have to fallback to ...Andrei-Sokalau2 hours agoNew MemberNew3Views0likes0CommentsProvide a Read-Only / Source-Safe Mode for Schema Shortcuts in Lakehouse
Schema Shortcuts provide a much better management experience than individual Table Shortcuts because they preserve the source schema structure and allow multiple tables to be onboarded at once. Howev...Junghyoen4 hours agoMicrosoft EmployeeNew22Views8likes0CommentsAccess Variable Library in Semantic Models
Enable the Variable Library as a centralized location for storing all environment‑specific variables, allowing us to adjust them for promotion scenarios (e.g., from dev to prod) without relying on de...FreddyH15 hours agoAdvocate IINew920Views31likes2CommentsEnhance Fabric Pipeline Monitoring with Parent-Child Pipeline Lineage and Parameter Visibility
Currently, Microsoft Fabric Pipeline monitoring lacks several capabilities that are available in Azure Data Factory, making troubleshooting and operational support challenging in enterprise environme...dwramreddy16 hours agoRegular VisitorNew8Views0likes0CommentsDynamic ADLS-Gen2 path input for Spark Jobs Main definition file
I would like the ability to add a dynamic input box on a spark job definition's "Main Definition File" "ADLS-Gen2 path". this would be useful to set base and variable paths across all spark jobs...mfink_db20 hours agoNew MemberNew238Views2likes2Comments