Introducing our native Microsoft SQL Server source 🎉

We’re thrilled to announce native support for Microsoft SQL Server—our most requested source from users! 🎉

With this new source, you can now replicate data from your SQL Server databases directly into Materialize in real time, using SQL Server's built-in Change Data Capture (CDC) functionality.

For many organizations, SQL Server is a backbone of their operations. With a native integration to Materialize, this means:

• No Kafka, no Debezium, no extra infrastructure. Ingest SQL Server change data into Materialize in real time with no architectural changes or additional operational overhead.
• Transactional consistency. The SQL Server source ensures that transactions in the upstream database are respected downstream. Materialize will never show partial results based on partially replicated or partially applied transactions.
• Incrementally updated materialized views. When paired with Materialize, you can maintain arbitrarily complex materialized views over your SQL Server data that are always fresh.

Once you’ve enabled CDC on your SQL Server database, setting up a source in Materialize is quick and straightforward:

CREATE SECRET sqlserver_pass AS '<SQLSERVER_PASSWORD>';

CREATE CONNECTION sqlserver_conn TO SQL SERVER (

    HOST '<hostname>',

    PORT 1433,

    USER '<username>',

    PASSWORD SECRET sqlserver_pass,

    DATABASE '<database>'

);

CREATE SOURCE mz_source

  FROM SQL SERVER CONNECTION sqlserver_conn

  FOR ALL TABLES;

For setup instructions, current limitations, and integration guidance, check out the full SQL Server ingestion docs and feature overview.

We're excited to bring the power of Materialize directly to the SQL Server ecosystem. Start your free trial or join us on Slack — we’d love to hear what you’re building!