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.
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:
- DDL Translation: Azure Synapse Pathway
- Abstracted Data Migration: OmniLoader
Hope this can help your organization jumpstart the Data Warehouse migration from SQL Server to Azure Synapse Analytics.