Frequently asked questions

The questions that determine whether replication survives production.

SQL Flow supports initial load plus CDC, one-way and multi-master topologies, automatic failover, schema evolution, distributed agents, and mixed destinations.

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.

Yes. Seed + Stream catches up from a pinned position. Multi-master lets you choose the conflict winner per table and prevents loops automatically. HA adds leases, fencing, reassignment, and source-aware resume. SQL Flow handles initial load begins a continuous pipeline; one stream fans out to many sinks; choosing the conflict winner per table; failover keeps one fenced owner.

Why this path matters

Does it handle initial load, multi-master, and failover?

Yes. Seed + Stream catches up from a pinned position. Multi-master lets you choose the conflict winner per table and prevents loops automatically. HA adds leases, fencing, reassignment, and source-aware resume. SQL Flow handles initial load begins a continuous pipeline; one stream fans out to many sinks; choosing the conflict winner per table; failover keeps one fenced owner.

What changes for you

Agents resolve secrets and move rows locally. Schema changes travel as ordered events. Durable spools absorb target and network outages. SQL Flow handles row data stays in the data plane; outbound agents fit restrictive networks; unsafe DDL pauses visibly; delivery semantics are declared per path.

The outcome

Tell us engines, network, write topology, tables, and recovery objectives. We will answer precisely.

The payoff

See what the capability changes.

Sources

What can it capture?

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

Targets

Where can changes go?

Eleven database, stream, and Fabric sinks.

Topology

Where does it run?

On-prem, cloud, hybrid, relay-split, and HA.

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.

Product and topology

Does it handle initial load, multi-master, and failover?

Yes. Seed + Stream catches up from a pinned position. Multi-master lets you choose the conflict winner per table and prevents loops automatically. HA adds leases, fencing, reassignment, and source-aware resume.

SQL Flow handles initial load begins a continuous pipeline; one stream fans out to many sinks; choosing the conflict winner per table; failover keeps one fenced owner.

  • Initial load begins a continuous pipeline
  • One stream fans out to many sinks
  • Choose the conflict winner per table
  • Failover keeps one fenced owner

Operations and trust

What crosses the control plane?

Agents resolve secrets and move rows locally. Schema changes travel as ordered events. Durable spools absorb target and network outages.

SQL Flow handles row data stays in the data plane; outbound agents fit restrictive networks; unsafe DDL pauses visibly; delivery semantics are declared per path.

  • Row data stays in the data plane
  • Outbound agents fit restrictive networks
  • Unsafe DDL pauses visibly
  • Delivery semantics are declared per path

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 load begins a continuous pipeline
  • One stream fans out to many sinks
  • Choose the conflict winner per table
  • Failover keeps one fenced owner
  • Row data stays in the data plane
  • Outbound agents fit restrictive networks

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. Does it handle initial load, multi-master, and failover?

    Yes. Seed + Stream catches up from a pinned position. Multi-master lets you choose the conflict winner per table and prevents loops automatically. HA adds leases, fencing, reassignment, and source-aware resume. SQL Flow handles initial load begins a continuous pipeline; one stream fans out to many sinks; choosing the conflict winner per table; failover keeps one fenced owner.

  2. What crosses the control plane?

    Agents resolve secrets and move rows locally. Schema changes travel as ordered events. Durable spools absorb target and network outages. SQL Flow handles row data stays in the data plane; outbound agents fit restrictive networks; unsafe DDL pauses visibly; delivery semantics are declared per path.

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

  • What can it capture?
  • Where can changes go?
  • Does it handle initial load, multi-master, and failover?
  • What crosses the control plane?
  • Ask the environment-specific question.

Take the next step

Ask the environment-specific question.

Tell us engines, network, write topology, tables, and recovery objectives. We will answer precisely.

Talk through my use case