Microsoft Fabric Open Mirroring

Turn database changes into continuously mirrored Fabric data.

SQL Flow captures committed changes, produces Fabric Open Mirroring change files, and publishes them through OneLake or a controlled staging path.

The job to be done

Move committed data with a path your team can explain.

A capability matters when it removes an operational decision, not when it adds another checkbox. SQL Flow connects source-aware capture, durable progress, target apply, and validation so the page you are reading leads to a usable operating path.

The Fabric sink groups source changes into target table specifications and advances its cursor only after its delivery contract succeeds. SQL Flow handles initial snapshot backfill; insert, update, and delete change files; OneLake or local staging workflows; per-destination lag and checkpoint.

Why this path matters

Publish the shape Open Mirroring expects.

The Fabric sink groups source changes into target table specifications and advances its cursor only after its delivery contract succeeds. SQL Flow handles initial snapshot backfill; insert, update, and delete change files; OneLake or local staging workflows; per-destination lag and checkpoint.

What changes for you

Use the same captured stream for Fabric and other destinations. A Fabric delay accumulates on its own durable cursor. SQL Flow handles independent Fabric backlog and retry; parallel fan-out to other destinations; capture mode chosen by source access; control-plane throughput and health.

The outcome

Tell us the source, table set, Fabric path, and freshness goal. We will map backfill, CDC, and delivery.

The payoff

See what the capability changes.

5

Source families

Oracle, SQL Server, PostgreSQL, MySQL, and Sybase.

Parquet

Mirroring files

Emit Fabric-compatible files with durable progress.

1 path

Backfill + CDC

Seed the mirror, catch up, and stay current.

Where the work happens

The details that make the result usable.

Read each capability as part of the operating path. The important question is not whether a feature exists, but what work it removes and what evidence it leaves behind.

Fabric-native delivery

Publish the shape Open Mirroring expects.

The Fabric sink groups source changes into target table specifications and advances its cursor only after its delivery contract succeeds.

SQL Flow handles initial snapshot backfill; insert, update, and delete change files; OneLake or local staging workflows; per-destination lag and checkpoint.

  • Initial snapshot backfill
  • Insert, update, and delete change files
  • OneLake or local staging workflows
  • Per-destination lag and checkpoint

One source reader

Fabric does not add another capture process.

Use the same captured stream for Fabric and other destinations. A Fabric delay accumulates on its own durable cursor.

SQL Flow handles independent Fabric backlog and retry; parallel fan-out to other destinations; capture mode chosen by source access; control-plane throughput and health.

  • Independent Fabric backlog and retry
  • Parallel fan-out to other destinations
  • Capture mode chosen by source access
  • Control-plane throughput and health

Before you choose

Check the path against your environment.

Use the page-specific details below as a short discovery checklist. They are the conditions and work areas that shape the capability, not generic product promises.

  • Initial snapshot backfill
  • Insert, update, and delete change files
  • OneLake or local staging workflows
  • Per-destination lag and checkpoint
  • Independent Fabric backlog and retry
  • Parallel fan-out to other destinations

The path to confidence

See the work. Make the call. Prove the result.

The page keeps the product detail close to the decision it supports. Your team can see what the software handles automatically, what it changes for the target, and what the result leaves ready to operate.

  1. Publish the shape Open Mirroring expects.

    The Fabric sink groups source changes into target table specifications and advances its cursor only after its delivery contract succeeds. SQL Flow handles initial snapshot backfill; insert, update, and delete change files; OneLake or local staging workflows; per-destination lag and checkpoint.

  2. Fabric does not add another capture process.

    Use the same captured stream for Fabric and other destinations. A Fabric delay accumulates on its own durable cursor. SQL Flow handles independent Fabric backlog and retry; parallel fan-out to other destinations; capture mode chosen by source access; control-plane throughput and health.

Keep the plan connected

Take the next useful step.

A capability becomes easier to operate when the next decision follows from the constraint you just uncovered. Explore the related work that completes this part of the path.

Your working set

What this page leaves you with

  • Source families
  • Mirroring files
  • Publish the shape Open Mirroring expects.
  • Fabric does not add another capture process.
  • Keep Fabric current from the logs you already write.

Take the next step

Keep Fabric current from the logs you already write.

Tell us the source, table set, Fabric path, and freshness goal. We will map backfill, CDC, and delivery.

Talk through my use case