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 & Steps	Supported Targets
Ingestion Job Create a staging table in the data lake Create an ingestion job to load data into the staging table Create a transformation job for each target	Amazon Redshift Amazon S3 AWS Glue Data Catalog ClickHouse Elasticsearch Polaris Catalog PostgreSQL Snowflake
Replication Job Create a replication job to ingest into multiple target schemas	Amazon Redshift AWS Glue Data Catalog Polaris Catalog Snowflake
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	Amazon Redshift AWS Glue Data Catalog Polaris Catalog Snowflake

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.

---

Related Content

Quickstarts

• Create a Microsoft SQL Server Connection
• Ingest Your Data from Microsoft SQL Server

How To Guides

• Create and Maintain Connections to Your Microsoft SQL Server Database
• Replicate CDC Data to Multiple Schemas in Your Target
• Ingest Your Microsoft SQL Server CDC Data to Snowflake

Reference

• Connection Options for Microsoft SQL Server

• Ingestion Job Options for Microsoft SQL Server

• Replication Job Options for Microsoft SQL Server

Articles

• Ingest Data Using CDC
• Performing Snapshots