Microsoft SQL Server

Learn the steps for ingesting your Microsoft SQL Server data into your target.

Steps

  1. Enable CDC for your source Microsoft SQL Server database.

  2. Create a connection to your source Microsoft SQL Server database.

  3. Create a connection to your target (see the Supported Targets list below for links).

  4. Create the entities for your target per the list in the Job Type & Steps column below. Note that there are multiple options for ingesting to Snowflake:

Job Type & StepsSupported Targets

Ingestion Job

Replication Job

Single Entity Job

  • Create a staging table in the data lake

  • Create an ingestion job to load data into the staging table

  • Create a single entity job that auto-creates a sub-job for each source table to copy data to the target table

No-code Wizard

Alternatively, you can use the Upsolver no-code Wizard to get your pipelines started in super-quick time. The Wizard generates the code for you so you can optionally customize it for your requirements, and create advanced use cases.


Quickstarts

How To Guides

Reference

Articles

Last updated