Analysis Services X Synapse Analytics

Alfredo Garavelo 0 Reputation points
2023-01-30T17:56:37.9033333+00:00

How to migrate Analysis Services for Synapse Analytics

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,346 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. JIAN WANG 335 Reputation points
    2023-01-30T18:41:47.98+00:00

    Hi,

    It depens on your business complexity. ( i assume you migrate from local to Azure).

    If the current one running well.

    then, you should to consider the application DBs, the stageDB, any ETL,

    DW, any reporting services reply on it ....

    1. Applications DBs, any plan to migrate to Azure ,if not, any subscription for those DBs, need to use some middle layer DB combine data gateway on-premises, you can call it pre-stageDB whatever you like.
    2. ETL , if use 3rd solution, if so, be better to consultant this process, if wrorte by youself, might easy to verify.
    3. any SSIS package deployed, you have to upgrade the SSIS solution to use Azure enabled one.
    4. Schema need to be verified, and if any acess right defintion applied.
    5. quite many factors you should consider.
    6. you need a small team if you don't have much time or if you don't have enough access right.

    If the business rules need to be redefined, make sure the team members who involve the project have perfect understanding of the business.

    0 comments
  2. BhargavaGunnam-MSFT 25,876 Reputation points Microsoft Employee
    2023-02-09T01:53:45.43+00:00

    Thank you @Telen Wang,

    Hello @Alfredo Garavelo,

    Welcome to the MS Q&A platform.

    We have Microsoft documentation on migrating a DWH to a dedicated SQL pool in Azure synapse analytics.

    Please see the below document for your reference. Let us know if you have any further questions.

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