Skip to main content
SQL Server · change data capture

Replicate SQL Server to your cloud warehouse.

Describe the sync in plain English, approve it once, and rsync.ai streams every change from SQL Server into BigQuery, Databricks, or Postgres— continuously, from SQL Server's native CDC.

Real-time CDCYou approve every syncNo per-row pricing
Connect SQL Server free →See how a sync runs
Reads SQL Server's native CDC tables You approve before anything moves
Destinations

Send SQL Server data where your team already works.

Pick where it lands. rsync.ai builds and runs the pipeline — you approve it before anything moves.

Cloud warehouse

Land typed, query-ready tables for BI and analytics — incremental after the first snapshot.

BigQueryDatabricksSnowflakeRedshift

Another database

Replicate SQL Server into Postgres or MySQL with automatic type mapping and real-time CDC.

PostgreSQLMySQL

Data lake / storage

Write Parquet, JSON, or CSV to object storage for your lake.

Amazon S3GCSAzure Blob
What syncs

Every SQL Server object your pipeline needs.

Tables
Views
Schemas
Primary keys
CDC change streams
Snapshot + incremental
DATETIME2 → TIMESTAMP
UNIQUEIDENTIFIER → UUID
How it works

Four steps. Nothing runs until you approve.

01

Describe it

Say what to replicate in plain English — no SQL, no connector config.

02

Review the plan

rsync.ai discovers the schema, maps types, and scans columns for likely personal data before a row moves.

03

Approve

Nothing runs until you say yes. Later schema changes are applied and recorded; only a dropped table waits for you.

04

Stream

CDC keeps the destination up to date continuously; a failed run resumes where it stopped.

After it lands

Then work with the data without leaving rsync.ai

Synced tables become something you can query, schedule and share in the same workspace.

SQL Explorer

Run SQL against your connections, with personal columns masked in previews; writes are gated by role and every write is audited.

SQL Explorer docs→

Models

Turn a query into a table that rebuilds on a schedule or when its inputs refresh, with version history and data checks.

Models docs→

Charts and Dashboards

Draw a model or saved query as a chart, then put charts on one live dashboard.

Charts→ · Dashboards→

Workflows and Ask rsync.ai

Schedule reports and data alerts to Slack or email. Describe one in plain English and Ask rsync.ai drafts it.

Scheduled reports→ · Ask rsync.ai→

Compare

Why teams move SQL Server this way.

What you care aboutSSIS / manualAWS DMSPer-row ETLrsync.ai
Set up without an engineerNoConsole formsRarelyPlain English
Native SQL Server CDC (change tables)BatchYesVariesYes
You approve before it runsn/aNoNoYes
Cost as volume growsYour timePer hour + I/ORises per rowPer GB, not per row
Run in your own VPCYesAWS onlyVariesYes

Straight about status: the SQL Server source and the BigQuery, Databricks, Postgres, MySQL, and storage destinations are live in production. Snowflake and Redshift are in preview. Self-hosting in your own VPC is available now — source-available under the rsync.ai Source-Available License — or run rsync.ai as a managed cloud.

FAQ

SQL Server replication — common questions

How fresh is the data?
You choose the schedule, from a few times a day down to near real time. rsync.ai reads SQL Server's native CDC change tables, so it writes only the rows that changed — and a failed run resumes where it stopped instead of starting over.
What does SQL Server need before CDC works?
CDC must be enabled on the database and on each table you replicate (sp_cdc_enable_db and sp_cdc_enable_table). Enabling it needs a login with sysadmin or db_owner. On SQL Server and managed instances, SQL Server Agent must be running because it runs the capture jobs; Azure SQL Database schedules capture itself. rsync.ai's pre-flight check flags what is missing.
Do I need to write SQL or configure a connector?
No. Describe the sync in plain English. rsync.ai discovers the schema, maps SQL Server types to the destination, scans columns for likely personal data, and shows you the plan. Nothing runs until you approve it.
Which SQL Server types are handled?
Common types map automatically — DATETIME2, UNIQUEIDENTIFIER, DECIMAL, NVARCHAR, BIT, and more — with the exact mapping shown in the review step before the first row moves, so there are no silent conversions.
How are you priced?
On data volume (GB moved), not per row or Monthly Active Rows. Each plan includes a monthly GB allowance (10 GB on the free month), and pipelines pause at your cap instead of running up charges.
Who controls what moves?
You do. No pipeline is created or started until you confirm the plan, PII rules apply before data lands, and later schema changes are applied and recorded (only a dropped table waits for a person). Self-hosting entirely in your own VPC is available now for teams that need data to never leave their network.

Put your SQL Server data in the warehouse.

Connect your database free and send your first live sync to BigQuery or Databricks today.

Connect SQL Server free →See how it works
Live on rsync.ai Cloud today · self-hosted (rsync.ai Source-Available License)