SOLVED

Migrate on-premier data base to Azure

%3CLINGO-SUB%20id%3D%22lingo-sub-2581132%22%20slang%3D%22en-US%22%3EMigrate%20on-premier%20data%20base%20to%20Azure%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2581132%22%20slang%3D%22en-US%22%3E%3CP%3Ewe%20are%20planning%20to%20migrate%20the%20on-premier%20database%20into%20Azure.%20Can%20anyone%20explain%20what%20Azure%20service%20we%20will%20need%3F%20We%20are%20planning%20use%20Azure%20synase%20as%20datawarehouse%20and%20Delta%20lake%20as%20storage.%20Any%20other%20service%20we%20should%20use%20(i.e%20IAM%2C%20ADF%2C%20Databrick)%3F%20The%20security%20is%20very%20sensitive%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2583820%22%20slang%3D%22en-US%22%3ERe%3A%20Migrate%20on-premier%20data%20base%20to%20Azure%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2583820%22%20slang%3D%22en-US%22%3EHave%20you%20looked%20at%20the%20Azure%20Database%20Migration%20Assistance%3F%3CBR%20%2F%3E*%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdma%2Fdma-overview%3Fview%3Dsql-server-ver15%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdma%2Fdma-overview%3Fview%3Dsql-server-ver15%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20have%20SSIS%20workloads%2C%20then%20go%20Azure%20Data%20factory%3CBR%20%2F%3EIf%20you%20have%20SQL%20Analysis%20services%2C%20then%20look%20at%20Azure%20Analysis%20Services%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597426%22%20slang%3D%22en-US%22%3ERe%3A%20Migrate%20on-premier%20data%20base%20to%20Azure%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597426%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20a%20lot.%20Really%20helpful%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F108279%22%20target%3D%22_blank%22%3E%40Luke%20Murray%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 

2 Replies
best response confirmed by Jenn Jinhong (Microsoft)
Solution
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

Thanks a lot. Really helpful@Luke Murray