Stream into SQL Server with your free account
Deliver data from databases, SaaS apps, APIs, files, and streaming systems into SQL Server using Estuary's pre-built connectors. Run pipelines from real-time streaming to scheduled batch based on connector capabilities.
- <100ms to batch
- 200+ connectors
- Managed data pipelines
SQL Server connector details
The Microsoft SQL Server materialization connector in Estuary delivers data from Estuary collections into tables in a SQL Server database. It supports continuous materialization from real-time or batch pipelines, using standard merge-based updates by default with optional delta updates for applicable workloads.
- Supports SQL Server 2017 and later
- Standard merge-based updates by default to keep destination records synchronized
- Optional delta updates for workloads where changes should be applied incrementally
- Automatic table creation for configured materialization bindings
- Configurable destination schema and table names
- Username and password authentication
- Azure IAM authentication for Azure SQL Database using an Azure App Registration
- AWS IAM authentication for supported AWS-hosted SQL Server configurations
- Direct connectivity or SSH tunneling for databases on private networks
- Automatic quoting of SQL Server reserved words when they appear as field names
- Option to exclude the root Flow document from standard updates for advanced use cases
Each binding maps an Estuary collection to a SQL Server table. The connector creates new destination tables as specified, so the configured database user must have permission to create tables.
For self-hosted SQL Server, Estuary can connect by allowlisting Estuary IP addresses or through an SSH tunnel. The same connector also supports Azure SQL Database, Amazon RDS for SQL Server, and Google Cloud SQL for SQL Server deployment patterns.
How to connect your data source to SQL Server in 3 easy steps
- 1
Connect your data source
Select from more than 100 supported databases and SaaS platforms including PostgreSQL, MySQL, SQL Server, MongoDB, and Kafka.
- 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 SQL Server
Continuously or periodically deliver data into your destination with support for change data capture and reliable delivery for accurate insights.
Learn more with some related videos
Dive deeper into SQL Server with tutorials and walkthroughs from our YouTube channel.
![SQL Server CDC to Snowflake + ClickHouse in Real Time (Fan-Out Demo) video thumbnail]()
SQL Server CDC to Snowflake + ClickHouse in Real Time (Fan-Out Demo)
See how to capture SQL Server change data once and fan it out to Snowflake, ClickHouse, and other destinations without creating duplicate source pipelines.
![Introducing Estuary Agent Skills: Build Data Pipelines with AI video thumbnail]()
Introducing Estuary Agent Skills: Build Data Pipelines with AI
Estuary Agent Skills give your AI coding assistant the Estuary-specific context it needs to build and operate real-time data pipelines. Ask in plain English, capture my Postgres database into Snowflake, load these collections into BigQuery, or why is this connector failing, and your assistant knows the workflow.
![Ingesting Data into BigQuery: How to set up a Materialization in Estuary video thumbnail]()
Ingesting Data into BigQuery: How to set up a Materialization in Estuary
Estuary is a real-time data integration platform that allows you to connect Cloud SQL to BigQuery and other data sources. Estuary is streaming native and has an intuitive no-code UI that’s quick to use once your data systems meet the prerequisites. Like Dataflow, it's also highly scaleable and hands-off once the initial setup is done.
Trusted by data teams worldwide
All data connections are fully encrypted in transit and at rest. Estuary also supports private cloud and BYOC deployments for maximum security and compliance.
![Together AI logo]()
Read success storyTogether AI
How Together AI Uses Near-Real-Time Data to Understand Inference Economics
![Logo for Envoy]()
Read success storyEnvoy
Right-Time Visibility for a High-Velocity Business: Envoy’s Estuary Story
![Logo for the Coltene Group]()
Read success storyColtene
From SAP on SQL Server to Snowflake: How Coltene Built Reliable Replication with Estuary
![Glossier logo]()
Read success storyGlossier
Glossier Runs Real-Time Supply Chain and Marketing Analytics with Estuary
HIGH THROUGHPUT
Distributed, event-driven architecture scales for demanding data workloads.
DURABLE COLLECTIONS
Store data as it moves so you can transform, replay, and deliver it downstream.
FLEXIBLE LATENCY
From <100ms CDC and real-time streaming to scheduled batch, depending on connector capabilities.
From <100ms to batch
Estuary supports CDC, real-time streaming, incremental syncs, and scheduled batch across its connector ecosystem. Bring data from databases, SaaS apps, APIs, files, and event streams into SQL Server, with capture and delivery cadence based on connector capabilities and pipeline configuration.
- Connect data from operational databases, SaaS applications, APIs, files, and streaming systems to SQL Server through Estuary.
- Transform and route data through Estuary collections before delivering it to SQL Server.
See what you can connect to SQL Server:
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
| Estuary | Batch ELT/ETL | DIY Python | Kafka | |
|---|---|---|---|---|
| Price | $ | $$-$$$$ | $-$$$$ | $-$$$$ |
| Latency | <100ms to scheduled | 5min+ | Varies | <100ms |
| Ease | Analysts can manage | Analysts can manage | Data Engineer | Senior Data Engineer |
| Scale | ||||
| Maintenance Effort | Low | Medium | High | High |
One platform for real-time and batch data pipelines
Deliver real-time and batch data from DBs, SaaS, APIs, and more
