Migrate On-Prem Data Warehouse to Azure synapse dedicated sql pool

Pankaj Mandania 41 Reputation points
2021-05-07T07:10:23.893+00:00

I am using the Database Management Assistant (DMA) )tool to asess out existing DW before the migration. There is also an option to migrate the data and schema inside this tool.

I couldnt find an option "azure synapse sql pool" or similar, so i was wondering if the DMA tool supports migration to azure synapse?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,107 questions
0 comments No comments
{count} votes

Accepted answer
  1. Vaibhav Chaudhari 38,426 Reputation points
    2021-05-07T08:43:53.123+00:00

    There is a detailed document available here. Hope that helps

    https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/migrate-to-synapse-analytics-guide?tabs=migratefromSQLServer

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav


0 additional answers

Sort by: Most helpful