Tools to help migrate to Azure Synapse Analytics

Now that we have covered the planning and preparation and an overview of the migration process, let's have a look at the tools that you can use for migrating your legacy data warehouse to Azure Synapse Analytics. The tools that we will discuss are:

• ADF
• Azure Data Warehouse Migration Utility
• Microsoft Services for Physical Data Transfer
• Microsoft Services for Data Ingestion

Let's get started.

ADF

ADF is a fully managed, pay-as-you-use, hybrid data integration service for cloud-scale ETL processing. It offers the following features:

• Processes and analyzes data in memory and in parallel to scale and maximize throughput
• Creates data warehouse migration pipelines that orchestrate and automate data movement, data transformation, and data loading into Azure Synapse Analytics
• Can also be used to modernize your data warehouse by ingesting data into Azure Data Lake, processing and analyzing...