<--- Back to all connectors

SQL Server

Stream changes from Microsoft SQL Server in real-time using Change Data Capture (CDC). Capture every insert, update, and delete from your SQL Server tables.

SQL Server

Stream SQL Server Changes in Real-Time

Key Features

  • Real-time CDC - Capture changes as they happen using SQL Server’s native CDC feature
  • Zero Performance Impact - Read from transaction log without affecting database performance
  • Schema Evolution - Automatically handle schema changes without manual intervention
  • Exactly-once Delivery - Guaranteed data consistency with exactly-once semantics

How It Works

Streamkap uses SQL Server’s native Change Data Capture feature to capture changes from your database. This means:

  1. No impact on your production database performance
  2. No need to modify your application code
  3. Changes are captured in the order they occurred
  4. Full support for inserts, updates, and deletes

Getting Started

  1. Enable CDC on your SQL Server database and tables
  2. Create a user with appropriate permissions
  3. Connect Streamkap to your database
  4. Start streaming data to your destination

Supported SQL Server Versions

  • SQL Server 2016+
  • SQL Server 2019
  • SQL Server 2022
  • Amazon RDS for SQL Server
  • Azure SQL Database
  • Azure SQL Managed Instance

Why Streamkap?

Reliable

Serverless platform providing enterprise reliability and scale.

Affordable

Only pay for GB into Streamkap.

Longterm

Retain data for as long as you need.

Flexible

Read once, write to many destinations.