SQL Server
SQL Server is a relational database management system developed by Microsoft Corporation.
You can read from SQL Server as follows, and write to any target supported by Striim. Typically, you will set up data pipelines that read from SQL Server in two phases—initial load, followed by continuous replication—as described in Building pipelines from SQL Server.
SQL Server feature summary
See also Feature comparison: MS SQL Reader and MSJet.
Feature | Initial load with Database Reader | Continuous real-time replication using MSSQL Reader | Continuous real-time replication using MSJET | Continuous incremental replication with Incremental Batch Reader |
|---|---|---|---|---|
Supported versions and services | ||||
SQL Server Enterprise 2008 | ✔ | ✔ | ✔ | |
SQL Server Enterprise 2012 | ✔ | ✔ | ✔ | |
SQL Server Enterprise 2017 in SQL Server 2012 compatibility mode | ✔ | ✔ | ✔ | ✔ |
SQL Server Enterprise 2014 | ✔ | ✔ | ✔ | |
SQL Server Standard and Enterprise 2016 through SP1 | ✔ | ✔ | ✔ | |
SQL Server Standard and Enterprise 2016 SP2 or higher | ✔ | ✔ | ✔ | ✔ |
SQL Server Standard and Enterprise 2017 | ✔ | ✔ | ✔ | ✔ |
SQL Server Standard and Enterprise 2019 | ✔ | ✔ | ✔ | ✔ |
SQL Server Standard and Enterprise 2022 | ✔ | ✔ | ✔ | ✔ |
Amazon RDS for SQL Server | ✔ | ✔ | ✔ | |
Azure SQL Database (S3 tier and above; Standard and Premium tiers (CDC is not supported for Basic tier) | ✔ | ✔ tables with binary or varbinary values ≥64KB cannot be read | ✔ | |
Azure SQL Database Managed Instance | ✔ | ✔ tables with binary or varbinary values ≥64KB cannot be read |
| ✔ |
Security and governance | ||||
SSL / TLS | TLS 1.2 | TLS 1.2 | TLS 1.2 | TLS 1.2 |
connection profile | ||||
Operations | ||||
initial load | ✓ | |||
initial schema creation | with supported targets | |||
schema evolution | ✔ | |||
DML operations replicable in target | INSERT, UPDATE, DELETE | BEGIN, INSERT, UPDATE, DELETE, COMMIT | INSERT (UPDATE handled as INSERT, DELETE ignored) | |
Building applications / programmability | ||||
automated pipelines | ✓ | ✓ | ✓ | |
other wizards | initial load only | change data capture only | change data capture only | initial load only |
Flow Designer | ✓ | ✓ | ✓ | ✓ |
TQL | ✓ | ✓ | ✓ | ✓ |
Runtime | ||||
output stream event type | WAEvent | WAEvent | WAEvent | WAEvent |
network connection fault tolerance | by JDBC driver | configurable automatic retries | configurable automatic retries | by JDBC driver |
recovery | ✓ | ✓ | ✓ | ✓ |
parallel threads | ✓ | not user-configurable | ✓ | |
metrics & auditing | ✓ | ✓ | ✓ | ✓ |