question

surya1509 avatar image
0 Votes"
surya1509 asked vipullag-MSFT commented

SSAS Multidimentional Cube Migration to Azure VM

Hi ,
I have a Azure virtual machine already setup with SSAS( in multidimensional mode )installed .
I need to migrate on prem SSAS cube to Azure VM , could you please let me know the different approaches that I can take to deploy /process the cube from onprem to Azure?

Also once Cube is moved to Azure VM the data source will be from Azure managed instance. Can i use any automation to process and deploy the cube using any CI/CD approach?

azure-virtual-machinessql-server-analysis-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@surya1509

Just checking in to see if you got a chance to see previous reply from CarrinWu.

Please 'Accept as answer' if the provided information is helpful, so that it can help others in the community looking for help on similar topics.

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @surya1509,

Welcome to Microsoft Q&A!

Based on my research, there is no automatic approaches to migrate on premise Multidimensional cube to Azure VM. The migration approaches as below:
1. Interactively using SSMS
2. Programmatically using AMO
3. By script using XMLA
4. Backup and Restore

Please refer to below links to get more information:
Move an Analysis Services Database
Backup and Restore of Analysis Services Databases
Deploy a Created Cube to a Different SSAS Server


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.