Migrating your Data Warehouse from SQL Server to Azure Synapse Analytics – Pass Data Community Summit 2021

We had a great live presentation on November Friday 12th, 2021, at the Data Community Summit 2021. My colleague Gail Zhou, and I, presented a set of feature parities, capabilities and recommendations when migrating a Data Warehouse from SQL Server to Azure Synapse Analytics Provisioned Pool. We also went ahead and provided a hands-on demo on how to a assess the environment, as well as how to migrate objects and data from SQL Server.

If you attended the summit, you are able to download the contents after logging in. If you were not able to attend, you can leverage the contents from links below, instead.

  1. Git: Azure Synapse Scripts And Accelerators Scripts
    1. Assessment with PowerBI
    2. Migrations

You can also take the opportunity to go over the assets on this YouTube Channel:

Assessing SQL Server and Creating a PowerBI Dashboard

Migrating from SQL Server to Azure Synapse Analytics Provisioned Pool

Step by Step Detailed Migration Video Playlist

There are additional assets that can be leveraged for your database migration:

  1. DDL Translation: Azure Synapse Pathway
  2. Abstracted Data Migration: OmniLoader

Hope this can help your organization jumpstart the Data Warehouse migration from SQL Server to Azure Synapse Analytics.