Forum Discussion

BillYang1234's avatar
BillYang1234
Copper Contributor
Jul 23, 2021
Solved

Migrate on-premier data base to Azure

we are planning to migrate the on-premier database into Azure. Can anyone explain what Azure service we will need? We are planning use Azure synase as datawarehouse and Delta lake as storage. Any other service we should use (i.e IAM, ADF, Databrick)? The security is very sensitive 

  • Have you looked at the Azure Database Migration Assistance?
    * https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15

    If you have SSIS workloads, then go Azure Data factory
    If you have SQL Analysis services, then look at Azure Analysis Services

2 Replies

  • Have you looked at the Azure Database Migration Assistance?
    * https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15

    If you have SSIS workloads, then go Azure Data factory
    If you have SQL Analysis services, then look at Azure Analysis Services