Home Original page

Move Azure SQL Server to Any Destination, Real-time ETL & CDC

icon

REAL-TIME ETL & CDC

Move your data from Azure SQL Server with your free account

Continously ingest and deliver both streaming and batch change data from 150+ of sources using Estuary's custom no-code connectors.

  • <100ms Data pipelines
  • 200+ Connectors
  • 2-5x less than batch ELT

01. Move from Azure SQL Server02. Transform in-flight03. Select a destination

Azure SQL Server logo
take a tour

The Microsoft SQL Server connector captures real-time change data (CDC) from your SQL Server database and streams it into Estuary collections, ensuring continuous synchronization across systems.

  • Continuous CDC ingestion: Streams inserts, updates, and deletes directly from SQL Server’s CDC change tables into Flow collections for real-time data pipelines.
  • Broad platform support: Works seamlessly across self-hosted, Azure SQL Database, Amazon RDS, and Google Cloud SQL instances.
  • Automatic schema and instance handling: Detects new capture instances when DDL changes occur (like added columns) and automatically transitions to updated change tables.
  • Granular permissions and automation: Supports automatic capture instance management and change table cleanup when granted db_owner privileges.
  • Flexible and secure connectivity: Connect via SSH tunneling or IP allowlisting for on-premise and cloud-hosted deployments.
  • Customizable configuration: Includes advanced tuning options for backfill chunk size, table skipping, and metadata tagging.

💡 Tip: For optimal reliability, enable Automatic Capture Instance Management to let Flow handle table-level CDC setup and schema evolution automatically, while ensuring the user has the necessary db_owner privileges.

How to connect Azure SQL Server to your destination in 3 easy steps

1

Connect Azure SQL Server as your data source

Securely connect Azure SQL Server and choose the objects, tables, or collections you need to sync.

2

Prepare and transform your data

Apply transformations and schema mapping as data moves whether you are streaming in real time or loading in batches.

3

Sync to your destination

Continuously or periodically deliver data to your destination with support for change data capture and reliable delivery for accurate insights.

Get Started Free

icon-2

HIGH THROUGHPUT

Distributed event-driven architecture enable boundless scaling with exactly-once semantics.

icon-3

DURABLE REPLICATION

Cloud storage backed CDC w/ heart beats ensures reliability, even if your destination is down.

icon-1

REAL-TIME INGESTION

Capture and relay every insert, update, and delete in milliseconds.

Real-timehigh throughput

Point a connector and replicate changes from Azure SQL Server in <100ms. Leverage high-availability, high-throughput Change Data Capture.Or choose from 200+ of batch and real-time connectors to move and transform data using ELT and ETL.

  • Ensure your Azure SQL Server insights always reflect the latest data by connecting your databases to Azure SQL Server with change data capture.
  • Or connect critical SaaS apps to Azure SQL Server with real-time data pipelines.

See how you can integrate Azure SQL Server with any destination:

Details

or choose from these popular data sources:

Don't see a connector?Request and our team will get back to you in 24 hours

Pipelines as fast as Kafka, easy as managed ELT/ETL, cheaper than building it.

Feature Comparison

EstuaryBatch ELT/ETLDIY PythonKafka
Price$$$-$$$$$-$$$$$-$$$$
Speed<100ms5min+Varies<100ms
EaseAnalysts can manageAnalysts can manageData EngineerSenior Data Engineer
Scale
Maintenance EffortLowMediumHighHigh

Detailed Comparison

Deliver real-time and batch data from DBs, SaaS, APIs, and more

Connection-1