SQL Server Setup

Prerequisites

• SQL Server 2016 or higher (Enterprise, Standard, Personal, Azure SQL Managed Instance), Azure SQL Database, or Amazon RDS for SQL Server.
• Network connectivity from the Supermetal agent to the server (default port 1433).

Setup

Supermetal supports two replication types for SQL Server sources.

• Capture Table Replication. Real time change data capture (CDC) with an initial snapshot.
• Snapshot. One time or scheduled full table snapshots.

Transactional Consistency

SQL Server CDC writes changes into a separate capture table per source table, splitting a multi table transaction's changes across capture tables. Supermetal reads them in one of two modes.

• Standard (default). Processes each capture table independently for the lowest latency. Suitable when consistency within each table is enough.
• Transactional (opt in). Reconstructs multi table transactions across capture tables, so related changes, such as an order and its line items, arrive together exactly as they were committed at the source.