question

LittyKuriakose-7666 avatar image
0 Votes"
LittyKuriakose-7666 asked LittyKuriakose-7666 commented

Migration from SSAS 2005 to SSAS 2019

Please provide inputs for migrating cubes from SSAS 2005 to 2019 version.

The cubes are to be deployed to a new server. Are there any premigration checklists to be noted?

Please provide information on the common upgrade issues

sql-server-analysis-services
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.

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered LittyKuriakose-7666 commented

Hi @LittyKuriakose-7666,

Thanks for your posting.

If you just migrate SSAS 2005 to 2019, I suggest that back up the old version and then restore to new version. For more information, please refer to below links:

Deploy a Created Cube to a Different SSAS Server
Upgrade Analysis Services

And is it your data source is SQL Server Database? If yes, you should also to check the Prerequisites for SQL Server. For more information, please refer to Upgrade SQL Server to SQL Server


Best regards,
Carrin


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.


· 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.

Thanks Carrin for your quick response

0 Votes 0 ·