Skip to main content

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.

  • For initial load, you can use Database Reader.Database Reader

  • For real-time continuous replication after initial load using CDC, you can use MS SQL Reader or MSJet (see SQL Server).SQL Server

  • If you choose not to enable CDC on the source database, you can use Incremental Batch Reader to read the new source data at regular intervals, allowing for updates in near real-time.Incremental Batch Reader

Typically, you can set up data pipelines that will read from SQL Server in two phases, as explained in this concept article on Pipelines.  The first step is the initial load, where you can create a point-in-time copy of the existing source SQL Server dataset at the target.  After the initial load has completed, you can start continuous replication by continuously reading the new data created in the SQL Server dataset after the initial load was started, and then writing this new source data to the target.

Supported services

Striim supports reading from the following SQL Server database services:

  • Generic SQL Server (self-managed; e.g., installed and managed on-premises or in a cloud VM)

  • Amazon RDS for SQL Server

  • Azure SQL Database

Striim UI wizards

You can read from SQLServer by creating a (Striim) App using any of the following ways:

  • Wizards

    • Automated applications (IL & CDC)

    • Initial Load only

    • CDC only

  • Flow DesignerCreating an app using the Flow Designer