SQL Server Setup

Prerequisites

Before you begin, ensure you have:

• SQL Server Requirements:

  • Version: SQL Server 2016 or higher
  • Supported Editions:
    • Standard SQL Server (Enterprise, Standard, Personal, Azure SQL Managed Instance)
    • Azure SQL Database
    • Amazon RDS for SQL Server
  Unsupported SQL Server Editions

  CDC is not supported on Azure Synapse, Azure SQL Edge, or Azure Synapse Serverless.

• Setup Requirements:

  • Database Permissions: Varies by replication type (see Setup for role-specific instructions)
  • Network Connectivity: Ensure Supermetal can reach your SQL Server (default port: 1433)

---

Setup

Supermetal supports two replication types for SQL Server sources:

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